SqlServer.Dts.DtsClient

This .NET Framework Class Library is provided by Microsoft.
The class library is contained in the file Microsoft.SqlServer.Dts.DtsClient.dll.

Coding

Add a reference to the assembly Microsoft.SqlServer.Dts.DtsClient and include the Microsoft.SqlServer.Dts.DtsClient namespace. Instantiate a new DtsConnection connection object. Set the connection string and open the connection.

VB.NET code sample
Imports Microsoft.SqlServer.Dts.DtsClient
Dim myConnection As DtsConnection = New DtsConnection()
myConnection.ConnectionString = myConnectionString
myConnection.Open()
' execute queries, etc
myConnection.Close()
C# code sample
using Microsoft.SqlServer.Dts.DtsClient;
DtsConnection myConnection = new DtsConnection();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
// execute queries, etc
myConnection.Close();

Description

To reference the file you might have to browse to the dll. By default it's in the "C:\Program Files\Microsoft SQL Server\100\DTS\Binn" directory.

Download

There is no 'SqlServer.Dts.DtsClient' installation package to download. (if you know about an installation package URL you can contribute to the community by submitting the info to us through this message form)

Connection Strings

The SqlServer.Dts.DtsClient class library can be used to connect to the following data sources:

Integration Services

To see available connection options, navigate to the connection strings reference by the above links.

Providers

Not the right library?

Try search the kb articles, Q&A content and every connection string here.

Or go to the Q&A forums where you can ask questions.

Browse every article in the knowledge base. Start over in the connection string reference.

Providers

Articlesread all »