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

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

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
 
 

Popular