SqlServer.Dts.DtsClient
This is a .NET Framework Class Library provided by Microsoft.
The class library is contained in the file Microsoft.SqlServer.Dts.DtsClient.dll.
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
C# code sample
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()
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();
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.;
Connection Strings
Additional info or comments on this class library? Want to submit content?
Send an e-mail to
Send an e-mail to
Selected Articles