DTS QUESTION

[swoodring]

Is there a way in a dts to say if it already exists to update otherwise to write the record. I'm having a file come across which I need to either update if it already exists or add it. Its pretty much a field for field copy.

 

[HoustonGuy]

This is a common task in data warehousing. I accomplish this using SQL code to check the file and then decide whether to update the table or insert into the table.



Cody ford
Data Mining, Cleansing and Reporting Specialist
codyjford@hotmail.com

SQL, VB6, Seagate Info/Crystal Reports

 

[swoodring]

Buthow do you do this in a dts? Usually you just say copy field 1 in table1 to field 1 in table 2. Where would you check first to see if it exists or don't you do it in a dts and just use a sql script to do it all instead?
Stacy

 

[foxdev]

Stacy, why not import everything into a staging table, then compare that to what is in the destination table using T-SQL statments. Robert Bradley

http://www.foxdev.com/

Do you have too much money? Visit

http://www.agrainofhope.org