SSIS 2008r2: Refer back to one table for values on two fields on import file to insert in another table
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!
.
August 22nd, 2015 5:48pm

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:37am

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

August 24th, 2015 6:40pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics