About changes madae in the Database

Posted by Ravi.Shankar89 under Sql Server on 10/18/2011 | Points: 10 | Views : 815 | Status : [Member] | Replies : 1

I am new to this SSIS. and now i m creating SSIS packages to retrive table data from Source DB to Destination DB. Now if any changes happen to source DB(inserting of any rows or deletion of some rows) should be reflected and intimated to the Destination DB also so wat can i do for tat? Can anyone please help in this .

Note : Please share me some notes for get Trained in SSIS Controls.




Posted by: Sriramnandha on: 10/27/2011 [Member] Starter | Points: 25

ALready u Retrive SourceDB to DistinationDB in your SSIS Pacakge is Wont Get new DataFrom Distination u need to Create Schedule Task in u your SSIS Package for mention some Time duration like 1 hour or 30 minutes u can get a latest Records from Source to Distination DB..

hope this will Help

Let me know any Questions



Ravi.Shankar89, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response