If you are having problems finding the DLL to reference to programmatically run an SSIS Package, you should find it in the following location:
%Program files%\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SQLServer.ManagedDTS.dll
Take note that you may have several directories under %Program files%\Microsoft SQL Server\ if you have upgraded through different versions of SQL Server. Try looking through each of these to find the correct version of Microsoft.SQLServer.ManagedDTS.dll
So assuming you installed it on C:\, you should find it in:
For SQL 2005:
C:\Program files\Microsoft SQL Server\90\SDK\Assemblies\Microsoft.SQLServer.ManagedDTS.dll
For SQL 2008:
C:\Program files\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SQLServer.ManagedDTS.dll
If you still can't find the Assembly, make sure you've installed the Client Tools SDK as shown below:
DDK
4 comments:
I can't find this screen in SQL Server 2005.
Is that the same as "Integration Services?"
Thanks. The tip about "Client Tools SDK" installation helped me.
You may need to look in Program Files (x86) if running x64.
Nice and informative post is written in a good manner. Thanks.
www.99CarRentals.com
Post a Comment