Sunday, 8 August 2010

Location of Microsoft.SqlServer.Dts.Runtime when Programmatically Running an SSIS 2008 Package

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:

remoteportal said...

I can't find this screen in SQL Server 2005.

Is that the same as "Integration Services?"

Morris Bahrami said...

Thanks. The tip about "Client Tools SDK" installation helped me.

aalia lyon said...

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

Jean-Pierre Fouche said...

You may need to look in Program Files (x86) if running x64.