In this post I am going to explain how to use multicast tool in SQL Server integration Service. Mainly this component is use for redirect you data into multiple destinations.
In this example I am using customer table as a Source table and using two destination table. called Customer_Destination1 and Customer_Destination2. To load source data into two destination table I am using Multicast component.
Initially we have data in the Customer table but does not have any records in the destination tables.
First create a project and package in the SQL Server integration Service.rename as Multicast
Create OLEDB Connection in the Connection manager window.If you already created you can use the same connection. I am using existing connection.
Drag and drop the Data flow task into control flow.
Double click on the Data Flow task and drag and drop OLE DB source into Data Flow tab.Then give Connection manager name and Source table name. Click ok.
Drag and Drop the Multicast component. Create link between OLE DB Source and multicast.
Drag and drop Two OLE DB Destinations.Create link between as below.
Execute the Package.
You can see the data As below.
Thank you !!!
In this example I am using customer table as a Source table and using two destination table. called Customer_Destination1 and Customer_Destination2. To load source data into two destination table I am using Multicast component.
Initially we have data in the Customer table but does not have any records in the destination tables.
SQL Server Integration Service (SSIS) 2017 - Multicast Transformation
Reviewed by Pubudu Dewagama
on
6:59:00 PM
Rating:
Reviewed by Pubudu Dewagama
on
6:59:00 PM
Rating:
No comments: