Loading ad...
Connection strings for Integration Services
Community Forums
Find solutions and post questions regarding connection string related issues.
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.
How to connect and read data from a SSIS package.
SqlServer.Dts.DtsClient
Type
.NET Framework Class Library
Usage Microsoft.SqlServer.Dts.DtsClient.DtsConnection
Manufacturer Microsoft
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
Selected Articles