Hi,
I have an requirement wherein I get the data in the form of an txt file and
I need to push this data onto different tables based on an column. And while
pushing these data onto different tables, I need to check whether the data
already exists in the table based on an unique column. If it is not present,
then I need to insert the record or should ignore that record.

I have used Character Map transformation to convert the column values from
lowercase to uppercase and I am using the conditional split transformation to
route the data onto different tables.

Now I am not able to check whether the record already exists in the
distination table or not. I am not able to find out which transformation
should I use for this. I am bit confused with the Lookup transformation that
we have.

Could any one please let me know the links where I can find some material
for this or if you have any materials, please send it to my personal id
sudhakaratp (AT) hotmail (DOT) com.

Thanks & Regards,
Sudhakara.T.P.

You can do this using the OLE DB Transformation. Add the Data Flow task. On
the Data Flow tab, add the OLE DB Transform. Enter the SQL command you want
to execute for each row - you will need to include question mark place
holders for the parameters. For more details, see Books Online.

Hope this helps.

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email alias: charles
email domain: kangai.demon.co.uk


"Sudhakara.T.P." wrote: