Data Flow Task is used to move data from a source to a destination while applying various transformations on the data being moved as and when required. The lab talks about available sources, transformations and destinations available in the data flow task. In the first exercise, we will learn to configure a data flow task to export a table from one SQL Server database to another SQL Server database. In the second exercise, we will configure the data flow task to get sales data from two csv file, calculate the tax deductions and total sales on the fly with in the Data flow task with the help of transformations and then insert the records into different tables filtered on different territories.
Exercise 1: Configure Data Flow Task to export table data from one SQL Server Database to another SQL Server Database
Exercise 2: Create a SSIS package to write a real world ETL solution