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)