<<<November 2014>>>
 SMTWTFS
44      1
452345678
469101112131415
4716171819202122
4823242526272829
4930      

Display as : cloud | list

RSS

Go Back

Developing SSIS Pacages - Create Project Data Sources

 

In this tutorial, you will create two project data sources, which will be used in your packages

as the source and the destination.

 

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 (if it is not already displayed). You can open Solution Explorer by clicking the

Solution Explorer button on the Standard toolbar.

 

 

2. In Solution Explorer, right-click the Data Sources folder, and then click New Data

Source. When the Welcome page of the Data Source Wizard appears, click Next.

 

 

3. On the Select How To Define The Connection page, select Create A Data Source Based

On An Existing Or New Connection.

 

 

4. Click New to open the Connection Manager dialog box.

 

 

5. In the Provider drop-down list, select the Native OLE DB\SQL Server Native Client 10

provider and click OK. Type (local) in the Server Name field.

6. In the Select Or Enter A Database Name drop-down list, select AdventureWorks2008.

 

7. Click the Test Connection button, and then click OK. Click OK again to close the Connection

Manager dialog box.

 

8. Select the (local).AdventureWorks2008 data connection in the Data Connections list,

and then click Finish in the Data Source Wizard.

 

9. The Completing The Wizard page prompts you to enter a name for the new project

data source. Type AdventureWorks2008 in the Data Source Name box, and then click

Finish. Be sure to remove the space between Adventure and Works2008.

 

10. Next, repeat steps 2 to 9 to create a new project data source for the (local).Adventure-

WorksDW2008 database, and name this data source AdventureWorksDW2008.

 

11. When you are finished creating the data sources, click the Save All button on the BIDS

toolbar.

References

MCTS Self-Paced Training Kit (Exam 70-448): Microsoft® SQL Server® 2008 Business Intelligence Development and Maintenance (Self-Paced Training Kits)