How to avoid the duplicate records in DTS transformations..

For example.. I have an OLTP data.. so i like to transfer the data for every day.. based on the DTS Scheduler.. but i need to avoid the duplicate data...becaz the yesterday should transfer again for today..

I have to write any special query for that??

-- Anonymous, September 27, 2004

Answers

Arul,

That will require that you keep track of when each record was created or last updated. (For instance, with a creat_date_time and last_updt_date_time column.) Then your DTS package would be able to transfer the records for today.

Hope this helps,

Eric

-- Anonymous, September 27, 2004