Overview
Package Connection Manager is SSIS Connection Manager for establishing connections to SSIS packages. It allows access to current or another package at runtime. This is important extension of the SSIS framework, which makes components like Data Flow Source possible. The configuration dialog allows connection setup to the current package or another package. Use the API to build components based on the Package Connection Manager.
Parameters
General
Use the Package Connection Manager dialog to specify properties for connecting to SSIS package. Please check the parameters below, when setting connection to a package other than the current.
Specify the password to use to decrypt package.
Specify the type of package storage location. This property has the options listed in the following table.
Value Description SSISDB Catalog Package is stored in SSISDB Catalog. Selecting this value displays the dynamic option Server, Authentication type, Package path.1.9 SQL Server Package is stored in SQL Server. Selecting this value displays the dynamic option Server, Authentication type, Package path. File System Package is stored on a file share. Selecting this value displays the dynamic options Package path. SSIS Package Store Package is stored in SSIS Package Store. Selecting this value displays the dynamic options Server, Package path. Specify server name or select a server from the list.
Specify authentication type. This property has the options listed in the following table.
Value Description Windows Authentication User is authenticated using standard Windows Authentication. SQL Server Authentication User is authenticated with SQL Server Authentication. Selecting this value displays the dynamic options User name, Password. Specify user name to access the SQL server.
Specify password to access the SQL server.
Type the package path, or click the browse button (...) and locate the package.
For SSISDB Catalog mode the expected format of the path is SSISDB\MyFolder\MyProject\MyPackage.dtsx
Specify values for the package variables/parameters when the Package Connection Manager is used for executing an external package (e.g. in a scenario with Data Flow Source )
Knowledge Base
- Where can I find the documentation for the Package Connection?
- How to script and modify the variables of Package connection
Related scripts
What's New
- Fixed: Dialog did not display properly in High DPI mode.
- New: Support for packages stored in Integration Services (SSISDB) Catalog
- Fixed: If connection settings get invalid, Visual Studio no longer crashes when opening the editor.
- Fixed: In SQL Server mode, the "ServerUser" parameter was not saved.
- New: Support for latest SSDT (15.8.x) in Visual Studio 2017
- Fixed: Retrieve of related Package object is now more robust.
- New: Introduced connection.
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.