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.

Subscribe to Download


Version1.0
Download1
File Size1.94 MB
Create DateOctober 5, 2016
Last UpdatedOctober 5, 2016
SSIS Data Flow Transformations Part 2
Troubleshooting SQL Server with WinDbg