Last post May 02, 2012 11:01 AM by Chen Yu - MSFT
Apr 27, 2012 06: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 09:38 AM|kelviyean|LINK
Follow the article below. It may help you.
May 02, 2012 11:01 AM|Chen Yu - MSFT|LINK
From your description, I found this thread which may help you to solve your problem.