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

Forum for Integration Services