Haven't got Microsoft.SqlServer.ManagedDTS.dll but

Question

I am trying to write a .NET program so I can execute a Dts pacakge but I cannot find the Microsoft.SqlServer.ManagedDTS.dll reference so I can then use the namespace Microsoft.SqlServer.Dts.Runtime.

However I have SQL Server 2008 Developer edition installed on my development machine along with Visual Studio 2008 and 2010. Therefore it should be there, What have I missed?

Many thanks

Mike

Answer 1

In References, browse to this directory:

C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies

hopefully you'll find it there.

The above was for SQL Server 2005. It should be located in your GAC. Have a look in:

C:\Windows\assembly

for the DLL as Visual Studio won't list all of the DLLs so you'll have to browse to it.

Answer 2

For Windows 7 "Microsoft.SqlServer.ManagedDTS" can be found in following path

"C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SqlServer.ManagedDTS\"