I have a source database 'DB_Srce'.
Now, my work is to create a package.If I run the package for the first time,it loads all the objects (tables/SPs/ and etc) into the DB_Destn databse and the subsequent runs (may be schedules time),it fetches only the modified records (inset/update/delete)
to the destination database. I think it involves CDC feature. I am new to SSIS.Could you please help with the steps,please?
View Complete Post