Hi
I am trying to run a SSIS package first time through vb.net console application. As the first step, i was trying to add the reference for Microsoft.SqlServer.ManagedDTS assembly but it was not in the available assemblies list box in visual studio 2003!
Please guide what i am supposed to do to get it, or if there any other alternative.
Thanks in advance
Utsav
In the Add Reference dialog window, click on the browse tab. Then navigate your way to:
C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies
There you will find the Microsoft.SQLServer.ManagedDTS.dll, select it and hit okay...
|||ManagedDTS runs in process. If the console app is running on a machine that does not have SSIS loaded on it you will not be able to reference the dll. The application will also crash at the point that you attempt to access DTS objects. This also causes problems if you are executing packages that contain static paths. Because the package runs on the client machine, the paths will be assumed to be local. My solution to this was to create a web service that executes the packages on the server. Unfortunately, this aproach seems to be a huge chore, as I am having problems passing the credentials to the package app object. If anyone has any experience with this, some guidance would be greatly appreciated.|||See Michael Entin's recent post on this (http://blogs.msdn.com/michen/default.aspx).
No comments:
Post a Comment