Hello, Can someone help me figure this out:
I receive a .csv file for import with let's say 3 rows neworgid, supplierneworgid for synchronization with our table a, that has orgid, supplierid
I create the SSIS package with data flow source: csv file, Multicast transformation to lookup 1 to match up supplier id with neworgid resulting in neworgid and another lookup 2 to match the org id to the neworgid. Then I put a union all transformation to a destination. What I get in the destination is 6 rows, 3 with the orgid, 3 with the supplierid. So I'm stuck. (and of course the deadline is looming!)
I need to read:
.csv file
neworgid - supplierneworgid
11 --- 22
33 --- 44
55 --- 66
into table a
orgid - supplierid
112 --- 222
332 --- 442
552 --- 662
Looking into table b (which I have cached)
orgid -- neworgid
112 --- 11
222 --- 22
332 --- 33
442 --- 44
552 --- 55
662 66
TIA everyone!
M.