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.
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.
Download link missing
The SqlServer.Dts.DtsClient installation package download link is missing. Please provide info and contribute to the community by email to
Connection Strings
Additional info or comments on this class library? Want to submit content?