Hi, I can't find the following namespace on any of my dev boxes
Microsoft.SqlServer.Dts.Runtime;
I have Visual Studio Team System 2008 on some machines and Visual Studio 2005 on some. What do I need to install to get this?
+1
A:
Most of the types in this namespace are from the Microsoft.SqlServer.ManagedDTS assembly. This is installed with SQL Server.
It sounds like SQL Server is not installed on this machine. Install a local copy, and it should find the assembly correctly.
Reed Copsey
2009-08-17 16:46:29
you are saying that I need to install SQL Server on my dev boxes? Can't SQL Express do?
Saif Khan
2009-08-17 16:48:15
You need to have the integration services installed: http://msdn.microsoft.com/en-us/library/ms141026.aspx This installs with the full version of SQL Server, but I don't believe it does with express. VS tries to install a dev version of SQL server - which you must have turned off with your VS installations.
Reed Copsey
2009-08-17 16:53:03
+1
A:
This is part of the Microsoft.SqlServer.ManagedDTS assembly and inside microsoft.sqlserver.manageddts.dll, it can be probably be found at C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies
It should be deployed with your SQL Server installation (you need to install the SDK portion of it).
kitsune
2009-08-17 16:46:51
Indeed, I added a reference to Microsoft.SqlServer.ManagedDTS and I am able to see the Microsoft.SqlServer.Dts.Runtime.
Saif Khan
2009-08-17 16:51:55
+1
A:
It is part of the SQL Server Integration Services, which is a part of the SQL Server setup. For information about which editions that support this, see Features Supported by the Editions of SQL Server 2008.
Fredrik Mörk
2009-08-17 16:49:05