I tried to create a package from a C# program, and I copied this from SQL server online book:using Microsoft.Sqlserver.Dts.Runtime;But I got compilation error:The type or namespace name 'Dts' does not exist in the namespace 'Microsoft.Sqlserver'(are you missing an asssembly reference?)What am I missing?Thanks a lot

Have you, in fact, set a reference to Microsoft.SqlServer.ManagedDTS ? This is the assembly that contains the Dts.Runtime namespace.-Doug

How do I set a reference to ManagedDTS? by writting:using Microsoft.SqlServer.ManagedDTS ?In this case ManagedDTS can not be found by compilerThanks for the hint

Please consult the Books Online for support. For example, the following article mentions what DLLs need to be registered: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9/html/e44bcc70-32d3-43e8-a84b-29aef819d5d3.htmregards,ash

found the solution: from visual studio, click Project->Add reference, then browse the assembly ManagedDTS.dll at directory c:\program files\microsoft sql server\90\SDK\Assemblies, this willl add ManagedDTS.dll to the project and solve the problem. Thanks everyone!

Hello, if you get this problem on your server. build your site in release mode and then you have this dll in your bin\release folder. Either find this DLL and upload that in your server bin directory manually

c:\program files\microsoft sql server\90\SDK\Assemblies in this path given by you i am unable to found Microsoft.SqlServer.ManagedDts.dll please help me

does that work for sql2008 ,i tried to add all dts related refrences but still i couldnt get ride of the error that i cant use import or name space microsoft sqlserver dts runtime . so for 2008 what best way to call ssis package through asp.net if stored procedure can you provide example or if you have other suggestion can you provide example