I am trying following scenario:--
In one Data Flow Task, I am fetching som data from SQL server using OledbSource. Then I am using a conditional split. I want to collect the resulting records in two diff recordset destinations.
Next I have a for each loop container, in this, I have two Data Flow Tasks. First one has oledb source which should be able to use first recordset and in second Data Flow Task--oledb source should be able to use second recordset.
Is it possible?
Can anyone tell me different options available in For Each Loop editor i.e. "Rows in first table", "Rows in all the tables" etc...
View Complete Post