I'm not sure if is possible in SSIS but I have 2 DataSet's and I would like to do a nested loop.
For Each Row in DataSet1 (loop through each header)
For Each Row in DataSet2 (loop through the details that are equal to the header)
To help you understand DataSet1 is the Headers and DataSet2 is the Details. Additionally the Header Rows are each numbered and the Detail Rows have the unique header row number in them.
I know I can do this in Scripting tasks but I just wondered if there was a proper/elegant way of doing it in SSIS.
Any help greatly appreciated.