Saturday, 18 April 2015

How to split the different columns (single table) into different destination by using SSIS transformations



Solution: The solution of the above problem by using multicast and sort operations as follows.



• Using OLE DB Source to get data from the database.
• Multicast is used to one to many datasources.
• In Sort1 select 3 Input columns Product_ID, Product_Name, Product_Qty and Sort the data by using Product_ID.


• In Sort2 select 2 Input columns Tax_Rate, Tax_Amount and Sort the data by using Product_ID.



• In Sort3 select 2 Input columns Revenue_Rate,Total_Revenue and Sort the data by using Product_ID.


• Destination1 is used to store the values of Product_ID, Product_Name, Product_Qty and mappings are

• Destination2 is used to store the values of Tax_Rate, Tax_Amount and mapping are


• Destination3 is used to store the values of Revenue_Rate,Total_Revenue and mapping are



• Final Output with Data viewers

No comments:

Post a Comment