Hello, Can someone help me figure this out:
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!
.
SSIS 2008r2: Refer back to one table for values on two fields on import file to insert in another table
August 22nd, 2015 5:47pm
You should use 'Conditional split Transformation' and not 'Multicast'. Can you make your example more clearer.
Free Windows Admin Tool Kit Click here and download it now
August 23rd, 2015 12:36am
This topic is archived. No further replies will be accepted.
Other recent topics
