Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

SSIS- Source file will be divided into Multiple Destinations

  • 14 April 2013
  • Author: Surendra
  • Number of views: 6896
  • 0 Comments

Scenario:  

Source file will be divided into Multiple Destinations.

Task Description:

We have 3 Different Sources and want to Combine and Split the data and Load data into 2 Destinations.

Step 1:

We have 3 Sources i.e.

Source 1: Oledb

Source 2: Flat File

Source 3: Excel


 

Step 2:

Combine these 3 sources

First I want to combine 2 sources and make it as one source here I am using Merge Transformation like below fig…

 Before going to join First I convert the data types by using Data conversion transformation why bcoz here our example we have flat file source when we join flat file source we must change the data types.

 

When we want use Merge transformation we must use Sort Transformation.

 

Step 3: 

In this step I combine 3 Sources by using Union all Transformation it loads all data from multiple sources.

 

Step 4: 

Then using Multicast Transformation we Split Data into Different Destinations

Step 5: 

By using Derived Column Transformation Split Emp table Data

 

By using Another Derived Column Transformation Split Department Table Data

 

 Step 6: 

Load Employee Data into One Table/Destination and Dept Data into another Destination

 

 

Step 7: 

Final out Put is

 

 

 

Print
Tags:
Rate this article:
5.0

SurendraSurendra

Other posts by Surendra

Please login or register to post comments.