error: 'Dts' does not exist in the namespace 'Microsoft.Sqlserver'

Hot Topic

Updating a record from table with data from a column of another record from the same table
ANN: Mobile Database Development Article
SSIS Script Component
A particular row to be bold??
MDX problem in AS2005
Error with install of sept CTP Enterprise edition
how to define a parameter in reporting services to choose to show/hide not null/null values?
New To Databasing
How to avoid HTTP 401 error with ASP 2.0 ReportViewer 2005 Std and two servers?
Problem in Deploying Analysis service projects using SQL server Business Intelligence Development Studio

SQL Server

Cannot insert explicit value for identity column
dataflow and expressions
How to detach properly using SQL Server Express?
Execution Plan Mystery
XML DataSource / Designer Dataset definition failure
SQL Server 2005 Integration Services DTS Package
SQL Server 2000: Add column before other column
SSIS Server Agent open the step problem
How to use Fields or ReportItems value in charts
Generating Reports With Enabled Parameters from Snaphots

error: 'Dts' does not exist in the namespace 'Microsoft.Sqlserver'

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

Answer this question

error: 'Dts' does not exist in the namespace 'Microsoft.Sqlserver'

  • Sai A

    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!

  • Tung

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

    -Doug

  • Wally_West

    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.htm


    regards,
    ash

  • perryf_00

    How do I set a reference to ManagedDTS by writting:
    using Microsoft.SqlServer.ManagedDTS  


    In this case ManagedDTS can not be found by compiler

    Thanks for the hint

  • Ankur gupta -

    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



  • error: 'Dts' does not exist in the namespace 'Microsoft.Sqlserver'
Answer this question