Menu
I'm quite new to Integration Services. Is it possible to have one data source that transfers data to multiple data destinations, or do I have to create as many sources as destinations? I have one CSV file containing data and I must distribute this data to different tables.
597
SQL Server Integration Services provides three different types of data flow components: sources, transformations, and destinations. Sources extract data from data stores such as tables and views in relational databases, files, and Analysis Services databases.
Multicast Transformation in SSIS sends input data to multiple destination paths without applying any conditions or transformations. OR, Takes ONE Input and makes the logical COPY of data and passes the same data to multiple outputs.
The difference between the two is that the Multicast transformation directs every row to every output, and the Conditional Split directs a row to a single output.
The Conditional Split transformation can route data rows to different outputs depending on the content of the data. The implementation of the Conditional Split transformation is similar to a CASE decision structure in a programming language.
In SSIS Data Flow task data flows through "pipes" or "streams". Each pipe can get to one destination only. To split a pipe into several pipes use Multicast from the Toolbox, when you are on Data Flow tab. Then link several pipes to their destinations.
85
You can also have multiple Data Flow tasks. So there can be multiple Data Flow tasks running in parallel (threads) or in sequence. You can then take the data from one destination table and use it as the source for another Data Flow.
33
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
