Microsoft Office Tutorials and References
In Depth Information
Figure 1-30. SSIS data flow using the Aggregate transformation
In many cases, you might actually get a flat file like this as input and want to extract it from and load it back into
your new database or an existing destination database. In that scenario, you’ll have to take this file as the input source,
identifying the columns based on the delimiter, and load it.
As mentioned before, you might have multiple data sources (such as two sorted datasets) that you want to merge.
You can use the merge module and load the sources into one file or dataset, or any other destination, as shown in
Figure 1-31 .
Figure 1-31. SSIS data flow merge options
■ if you have inputs you need to distribute to multiple destinations, you might want to use Multicast transformation,
which directs every row to all of the destinations.
Search JabSto ::