Monday, August 06, 2012 9:44 AM
May i know how to use CDC in SSIS / SQL SERVER 2005?
CAN U SEND ME THE STEPS R ANY LINK .
Monday, August 06, 2012 10:04 AM
As far as i understand CDC was introduced with SQL server 2008 and onwards, so 2005 it cant be attained.
However if you want to customise the behaviour you can do soo, this post might be helpful
Monday, August 06, 2012 10:09 AM
Here is a good article that may help you:
The article is quite explanatory, and uses all major use cases. you can trim down the example to suit your needs.
Hope this helps-