Data Normalization - Best approach?

Hi!

I wonder what would be the best (at to be honest - how to do it at all) to perform data normalization with SSIS. The scenario is as follows:

I got plain table with several columns in it.
Some of columns can be copied straight into destination table
Some columns (String) should be lookup in another table to get ID

On success just replace string with ID
On fail - create new record in lookup table and return newly created ID

Thanks for any ideas and maybe short samples

Anrijs Vitolins

Answer this question

Data Normalization - Best approach?

deumber

Yeah you can do all of this. This link will get you started regarding the lookup and putting new records into the lookup table - I recommend method 2: http://www.sqlis.com/default.aspx 311

You'll need a MULTICAST transform in there at some point as well by the sounds of it.

-Jamie
Data Normalization - Best approach?

Answer this question