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