SSIS - Connection
About
You can create connection managers at the project level or the package level.
- Project-level connection managers are listed in Solution Explorer and can be shared across multiple packages in the same project.
- Package-level connection managers exist only within the package in which they are defined.
Both project-level and package-level connection managers that are used by a package are shown in its Connection Managers pane in the SSIS Designer.
