Tags: 
API

Overview

Package Connection Manager component provides access to a package. When SSIS ConnectionManager.AcquireConnection method is called, it returns object implementing IPackageConnection interface. In order for you to use this interface in your project, you have to reference CozyRoc.SSISPlus.dll library.


IPackageConnection interface

Methods

Gets access to the Package object.

Prepares and executes package.

Waits for package to complete execution and performs cleanup.


Properties

Specify the type of package storage location. This property has the options listed in the following table.

Value Description
0 Connection to current package.
1 Package is stored in SQL Server.
2 Package is stored on a file share.
3 Package is stored in SSIS Package Store.

Specify the password to use to decrypt package.

Specify name of the server where the package is stored.

Specify user name to access the SQL server. Applies only when package location is specified to SQL Server.

Specify password to access the SQL server. Applies only when package location is specified to SQL Server.

Specify path to package.