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
5 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.
Excellent blog ,,,, its helps you to remove your rundll problem click this site How To Remove Rundll Error Free from error.
Thank you
Aalia lyon
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