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.
Knowledge Base
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.