Database Reference
In-Depth Information
Figure 7-4.
Selecting a project template for the DWPubsSalesETL project
We are using the Integration Services Project template. This template creates an integration service project
with one starter SSIS package. An SSIS project contains a collection of one or more SSIS packages, and each
package contains the programming instructions for your ETL process.
Be sure to give an appropriate name to your new integration service project. An appropriate name describes
its purpose. In Figure
7-4
, we have chosen to call it DWPubsSalesETL to indicate that its mission is to do the ETL
processing for the DWPubsSales data warehouse.
Renaming Your SSIS Package
When you first create a new SSIS project, Visual Studio immediately changes the layout by displaying the SSIS
package editor on the left of your screen, the Getting Started (SSIS) help window in the middle of your screen,
and the SSIS Toolbox on the right of your screen (Figure
7-5
).
Figure 7-5.
Visual Studio default look when creating a new SSIS project
