The scope of Connection manager for SSIS is divided into package and project

The scope of Connection manager for SSIS is divided into package and project, and the connection manager created in the package scope can only be used in the current package and cannot be used in other package All package can use Connection Manager in the current project scope.

1, create the package scope connection Manager

This localhost.db_study can only be used in the current package.

2. Create connection Manager for project scope

When Project.LocalHost.DB_Study.conmgr is created, the connection manager,ssis in the package's connection managers will precede the name (Project) To identify the scope of the Connection Manager is project.

If a connection manager is used by another package in project, creating Connection Manager in Project's connection managers is better, and when you modify the link, you only need to modify it once, All package references to the Connection Manager can be modified synchronously.

The scope of Connection manager for SSIS is divided into package and project