SSIS Records on the Same Row – kind of like pivot

(Mike Davis) If you have two or more records on the same row, and need to write each record on its own row in a destination, you have two choices. You can do this in series or parallel in a single data flow in SSIS. Here is the input table I am using for my example.

Read More - Register for Free Membership