In this tutorial, you will create a new SSIS project and then work with a couple of SSIS packages
by adding data sources and connections.
1. Start SQL Server Business Intelligence Development Studio (BIDS), by clicking the Start
button and then selecting All Programs, Microsoft SQL Server 2008, SQL Server Business
Intelligence Development Studio.
2. Choose New, Project from the File menu. (If you have Visual Studio 2008 installed
separately from BIDS, simply choose New Project from the File menu.) The New Project
dialog box displays all the installed templates for Microsoft Visual Studio, including the
Business Intelligence Projects templates.
3. In the New Project dialog box, confirm that Business Intelligence Projects is selected in
the Project Types area, and then in the Templates area, select the Integration Services
Project template.
4. Near the bottom of the New Project dialog box, in the Name box, type SSIS Project as the name of your SSIS project.
5. In the Location box, type the path, starting with the Documents folder in your user
profile: C:\SSISProject\. This is the same location where the practice exercise files for the Training Kit will be installed
by default.
6. Next, clear the Create Directory For Solution check box, which stores the SSIS project in
the folder you specified in step 5.
7. Click OK to have BIDS create the new SSIS project.
8. When the project is created, SSIS automatically creates a new SSIS package named
Package.dtsx and opens it in the SSIS Designer. In Solution Explorer, right-click
Package.dtsx, and then click Rename.
9. Rename the package by typing MyPackage.dtsx. BIDS might prompt you to rename
the package object. If a message box appears that prompts you to rename the package
object as well, click Yes. Always click Yes if you are prompted to change the package object
when renaming a package because this updates the internal name of the package.
10. Click the Save button on the toolbar, and then close the package by clicking the Close
button in the upper-right corner of the SSIS Designer.
11. To create a new package, right-click the SSIS Packages folder in Solution Explorer, and
then click New SSIS Package. This creates a new package object named Package1.dtsx
(the number depends on how many packages you have created) in the SSIS Packages
folder in Solution Explorer.
12. To rename the new package, right-click the package, and then click Rename. Rename
the package to DimCustomer.dtsx because this package will contain logic to process
the customer dimension table. When prompted, click Yes to rename the package object.
13. Following the same steps, create one more package in your SSIS Project named
DimPromotion.dtsx.
References
MCTS Self-Paced Training Kit (Exam 70-448): Microsoft® SQL Server® 2008 Business Intelligence Development and Maintenance (Self-Paced Training Kits)