This is what I'm trying to do.
(1) Get company IDs from Table A and stored that into Table B with identity value, and company name (seq_num)
(2) Table B will look like this:
Seq_Num | Company
1 | ABCD
2 | EFGH
3 | IJKL
4 | MNOF
(3) The loop starts from value 1 and the ending value is total number of rows (on this example 4)
(4) As the package loops through it matches current cycle # and seq_num and gets the company ID
(5) The transformation task will get the company ID ans use it to pull the data for transformation.
(6) The package is going to stop once it loops through all #s of rows.....