Connection strings for Integration Services

A client application can read the output of a package directly from memory, without the need for an intermediate step that persists the data. The key to this solution is the Microsoft.SqlServer.Dts.DtsClient namespace, which contains specialized implementations of the IDbConnection, IDbCommand, and IDbDataParameter interfaces from the System.Data namespace. Read more in this article, How to connect and read data from an SSIS package.

.NET libraries for Integration Services

SqlServer.Dts.DtsClient - DtsConnection

Developers Community

Find solutions and post questions regarding connection string related issues.

Forum for Integration Services

SqlServer.Dts.DtsClient

Type .NET Framework Class Library
Usage Microsoft.SqlServer.Dts.DtsClient.DtsConnection
Manufacturer Microsoft

More info and class library downloads

Set example values

Connecting to a package located in the file system

/FILE "C:\folder\DtsClientWParamPkg.dtsx"

Connecting to a package stored in msdb

/SQL packageName

Connecting to a package in the Integration Services package store

/DTS \folderName\packageName

Sign-in or Join