Multicast transformation is common transformation and It is used to provide data of Single source to Multiple destination.
This transformation has one Input and multiple Output.
For this transformation,We are explaining the example How to create multiple copy of single source data by using multicast Transformation.
In previous articles, We have explained to open BIDS and create a package.
Now we are going to explain how to use multicast Transformation.
Step 1) Drag and drop OLE DB Source, multicast Transformation,OLE-DB destination and Flat file destination from SSIS toolbox in data flow tab.
Step 2) Now Double click on OLE-DB source , OLE-DB source editor window will open and need to select table.
Step 3) Click on the columns tab to check the columns and click on “Ok” button.
Step 4) Double Click on OLE DB destination , OLE DB destination editor window will open to configuration table in which we need to send data .
Step 5) Click on the Mappings tab to check the columns and click on “Ok” button.
Step 6) Double Click on Flat file destination , Flat File destination editor window will open to select path where we need to send data .We require browse path and then click on “Ok” button.
Step 7) Click on the Mappings tab to check the columns.
Step 8) Click on “Ok” button to complete the configuration and execute the package to check the result in database.
Step 9) You can see the same number of rows are displaying for OLE DB destination and Flat File destination.
Step 10) Open SQL Server Management Studio to check the output in OLE DB destination and Flat File destination.
If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.
Clients will find it using our advanced search filter and will contact you directly.
No any charge for the product lsiting.