i have 2 data sources (i.e. 2 different tables) that i need to join and dumps the output to a destination table.
table a consists of 5 records while table b consists of 5000 records. they are being joined by a uniqueidentifier ID and the result will be inserted to table c as the destination.
I did the join by using the merge join tool (inner join) and did all the sorting steps but when I try to ran the data flow task, the step that runs the extraction from table a is finished first and then the OLE DB Destination : The final commit for the data insertion is ended before the extraction from table c has begun.
any idea where's the error here?
thanks a lot!