SSIS Data Flow Transformations – Part 1

Home/SSIS/SSIS Data Flow Transformations – Part 1

SSIS Data Flow Transformations – Part 1

$15.00 $4.00

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

Category:

Description

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

Data Platform Virtual Summit 2020

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin.

SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.