ssis update table changes and adds only

[jimbob]

Hi all,

Im not to sure if this is an easy thing to do or not however I am hoping somebody can point me in the right direction.

I am in a situation where I need to replicate report data from progress to sql for reporting. I have got this working with SSIS in SQL 2008 however I must truncate the table first in SQL to stop duplicates when running the import from progress.

I am looking for a way to only ADD new records and UPDATE changes only. Is this possible using T-SQL? or through any built in SSIS procedures?

Cheers

 

[mwpage]

Hey jimbob, I've been dealing with the same scenario over the past few months, I'm relatively new to SSIS, and even newer to Progress, but I have found a process that work really well. Andy Leonard has done an excellent job of explaining it here: http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/62063/ or you can check it out without registration here: http://sqlblog.com/blogs/andy_leonard/archive/2007/07/09/ssis-design-pattern-incremental-loads.aspx. I have modified mine quite a bit from what he did, but use the same underlying theory, I just extend it to not only inserts and updates, but also deletions. Hope that works for you, let me know if you have more questions on it.