I receive a .csv file for import with let's say 3 rows in fields 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!
.
I have the Multicast because I need to import some of the data into other tables. On this particular part of the import I have a lookup and then a conditional split.
To be clearer in what I need. I need to be able to look into a cached table for the database values that are equivalent to those that I receive.
In my cache I have values:
orgid -- neworgid
112 --- 11
222 --- 22
332 --- 33
442 --- 44
552 --- 55
662 66
What I get in the .csv file for import are:
neworgid - supplierneworgid
11 --- 22
33 --- 44
55 --- 66
Which should go into the destination table as:
orgid - supplierid
112 --- 222
332 --- 442
552 --- 662
I would like help in setting up this process: When I read 11, I look into the cached table and write 112 to the database, when I read 22, I look into the cached table and write 222 to the database, and so on.
Thank you very much!
Monica