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

sql-server-2008 c#-4.0 ssis
hydev picture hydev · Feb 7, 2011 · Viewed 36.7k times · Source

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

Neil Knight picture Neil Knight · Feb 7, 2011

In References, browse to this directory:

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

hopefully you'll find it there.

Related questions

How to backup Sql Database Programmatically in C#

I want to write a code to backup my Sql Server 2008 Database using C# in .Net 4 FrameWork. Can anyone help in this.

Read More
Error - The transaction associated with the current connection has completed but has not been disposed

I've been having trouble using the TransactionScope to wrap multiple database queries into a transaction, I am using SqlBulkCopy with batchsize 500. When I increased the batch size to 1000 I am getting the error: The transaction associated with the current connection …

Read More
Difference between Implicit and Explicit Transaction

What is the difference between Implicit and Explicit transaction in Sql Server 2008? What happens in TransactionScope background? I'm using TransactionScope but in Sql server profiler I don't see "Begin transaction..." statement. How does it work?

Read More