HELLO , May i know how to use CDC in SSIS / SQL SERVER 2005? CAN U SEND ME THE STEPS R ANY LINK .

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 http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/7597eea9-fab2-477b-a2a1-25ace9350ae0 Abhinav http://bishtabhinav.wordpress.com/

Here is a good article that may help you: http://www.sqlservercentral.com/articles/Change+Data+Capture+(CDC)/90155/ The article is quite explanatory, and uses all major use cases. you can trim down the example to suit your needs. Hope this helps-