Understanding the SSIS Interface
In this exercise, you will examine and execute a simple SSIS package that loads data into a dimension table by using the Data Flow task. You will then create a new project data source and a new package that mimics the design of the first package.
• Use Business Intelligence Development Studio to create a new project and add a pre-built package to a project.
• Execute a package and view the graphical presentation of package execution.
• Examine the new interface.
• Create a new data source.
• Create a new package, add a data source to the package, and use the Data Flow Task to load a dimension table with a Derived Column transform in the package.
