Package 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

GetPackage method

Gets access to the Package object.

Execute method

Prepares and executes package.

WaitToFinish method

Waits for package to complete execution and performs cleanup.

Location property (int)

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.
DecryptPassword property (string)

Specify the password to use to decrypt package.

ServerName property (string)

Specify name of the server where the package is stored.

ServerUser property (string)

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

ServerPassword property (string)

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

PackagePath property (string)

Specify path to package.