Hello I have moved the oracle 8i database into the staging with the same schema. Now i want to design a package by using SSIS which can pick the changes from each table in the oracle and load them into the sql server staging db. By changes i mean all inserts, Updates and deletes. I know about SSIS but please guide me atleast that what tasks should i use rest we can figure out atleast an idea will be helpful. Thanks In advanceFighttillend_DBA/DEV

Should be doable using one of the methods as posted here: Get all from Table A that isn't in Table B http://www.sqlis.com/post/Get-all-from-Table-A-that-isnt-in-Table-B.aspxArthur My Blog

http://sqlblog.com/blogs/andy_leonard/archive/2007/07/09/ssis-design-pattern-incremental-loads.aspxhttp://www.rad.pasfu.com

Couple of ways below With T-SQL 1. Create Staging database schema on SQL 2008 exactly same as Oracle. 2. Create linked server on staging SQL 2008 server onto Oracle. 3. Write T-SQL Queires (with OPENROWSET) to pull Full / Increamental data across to Stanging server every night. 4. Create a linked server from Target(Final) db server and above stanging sql server (If target and staging dbs are resides on difference servers) 5. Write T-SQL Queries (with Left Join) to pull data from SQL staging server onto server should be done after step 4 finished every night? With SSIS 1. Create Staging database schema on SQL 2008 exactly same as Oracle. 2. Create SSIS packages pull full / incremental feeds over night across to staging SQL 2008 from Oracle 3. Staging and production schema are same then you can use CDC change data capture option in SQL 2008 here is more http://www.mssqltips.com/tip.asp?tip=1755 both cases you have to scheduled them over night in SQL Agent Job Hope this might helps you http://uk.linkedin.com/in/ramjaddu

Thanks every body REZA I tried to use your link but i do not have any unique column to put in the lookup every column has repeating values so i am not sure. I think we need unique column right. ThanksFighttillend_DBA/DEV