<<<September 2014>>>
 SMTWTFS
36 123456
3778910111213
3814151617181920
3921222324252627
40282930    
41       

Display as : cloud | list

RSS

Go Back

Developing SSIS Packages - Create New Package Connections from the Project Data Sources

 

In this exercise, you will add the project data sources you just created to the two packages

that you have developed.

 

1. If necessary, start SQL Server Business Intelligence Development Studio (BIDS), open

the project you created in tutorial, SSIS Project, and then open Solution

Explorer. Edit your MyPackage.dtsx package by double-clicking the package in Solution

Explorer.

 

2. Locate the Connection Managers pane (at the bottom of the SSIS Designer window),

right-click in the pane, and then click New Connection From Data Source.

 

3. In the Select Data Source dialog box, select both the AdventureWorks2008 and

AdventureWorksDW2008 data sources from the list, and then click OK to accept. This

puts the two project data sources into the package’s Connection Managers pane.

 

4. Perform the same steps in the DimCustomer.dtsx package to add the Adventure-

Works2008 and AdventureWorksDW2008 project data sources as connection managers

for the package.

 

5. When you are finished creating the connection managers, click the Save All button on

the BIDS toolbar.

 

 

References