Last post May 02, 2012 10:01 AM by Chen Yu - MSFT
Apr 27, 2012 05:22 AM|raringsunny|LINK
Being a newbie to SSIS I need help with writing a package in SSIS to perform delta loads.
Is there any mechanism to identify the updates in the source system table records with those in the destination database tales?
Are there any built-in controls in SSIS that minimize the effort of writing the code manually?
We have a requirement wherein we need to insert new data, update existing data and delete any non-existent data from the destination system.
Would appreciate a prompt response.
Apr 27, 2012 08:38 AM|kelviyean|LINK
Follow the article below. It may help you.
May 02, 2012 10:01 AM|Chen Yu - MSFT|LINK
From your description, I found this thread which may help you to solve your problem.