Hi I want to pick the incremental changes form the oracle Database 8i to sql server 2008 r2. I have the data moved to sql server by the help of small SSIS packaged but i do not have something to pick the changes. Do any one know any idea for picking up those changes from the oracle db. Like either SSIS and the tasks and transforms i need to use????????? Or any other thing or tool which you guys know. Thanks in advanceFighttillend_DBA/DEV

Please check here http://stackoverflow.com/questions/155367/does-oracle-have-something-like-change-data-capture-in-sql-server-2008http://uk.linkedin.com/in/ramjaddu

Please see post Get all from Table A that isn't in Table B at http://www.sqlis.com/post/Get-all-from-Table-A-that-isnt-in-Table-B.aspxArthur My Blog