Here is another popular lab from Hands-On-Lab library: SSIS Data Flow Transformations – Part 1.
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
SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.