Assign Sources and Destinations (Integration Services Connections Project Wizard)
Use the Assign Sources and Destinations page to assign configured connection managers to a source, a destination, or both.
To run the Integration Services Connections Project Wizard
In Business Intelligence Development Studio, start a new project.
In the New Project dialog box, select Integration Services Connections Project Wizard.
Options
Connection Manager
Lists the configured connection managers that are available to assign to a source, a destination, or both.Source
Assign a configured connection manager to a source.Destination
Assign a configured connection manager to a destination.