How to use Conditional Split to Load Data To Multiple Tables in SSIS Package

In this video of SQL Server Integration Services(SSIS) Tutorial, you will learn how to divide the the records depending upon the data points and load them to related tables.

The video also covers

  1. How to create an SSIS Package
  2. How to use Data Flow Task in SSIS Task
  3. SSIS Package explains how to read the data from flat file source 
  4. How to use Conditional split to generate multiple outputs in SSIS Package
  5. How to write expressions in Conditional Split Transformation in SSIS Package
  6. How to load data to SQL Server Table in SSIS Package