Saturday, 09 January 2010 10:37

Understanding the SSIS Interface 1

Written by Vicky
Rate this item
(1 vote)

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.
 

Table 1
Last modified on Wednesday, 13 January 2010 18:18
Read 208 times
Published in MySQL
Social sharing
Vicky

Vicky

E-mail: This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Latest from Vicky

More in this category: « Producing XML Output using MySQL
back to top