Post reply

SSIS

  • April 25, 2007 at 2:45 pm

    #153547

     I have a requirement to move some data from our production database to a reporting database. I want to use SSIS to get the data into the system which I can do. But I'm wondering once I get the inital load done. How can i get the changes to the tables. Do I have to run the enitre SSIS package again to rebuild the destination tables. Or is there a way to just pick up the changes and move them to the destination tables.

     

    Thanks

    -WM

  • April 25, 2007 at 3:49 pm

    #702501

    It depends.  What are your requirements?  Out of the box, SSIS can not detect changes between databases.  You will have to write the process to identify changes and to move those changes to the reporting database.  The other choice is to simply do a truncate and load of the reporting database.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply