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

Display as : cloud | list

RSS

Go Back

Developing SSIS Packages - Create the Project and Packages

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)