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.
- 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.