Post reply

SQL server integration Services(SSIS)

  • November 14, 2007 at 12:18 am

    #119206

    Can anyone help regarding the SQL server integration Services(SSIS), ETL

    We have requirement like this:

    We have Live Database( LIVE_DB ) and Reports Database (REP_DB)

    I want to trasfer the few tables data from LIVE_DB into the REP_DB for end of the day using SSIS

    If any new records are added, updated or deleted in LIVE_DB, these should reflect in the REP_DB, Our requirement is not to delete the old data, we should append or delete or insert the new transaction data in REP_DB.

    Thanks in advance, if anyone help me in resolving this issue.

    Regards,

    Bhushanam.

  • November 14, 2007 at 3:54 pm

    #751298

    First, this is moved the the SSIS forum. You might get better responses there.

    Second, you'd need to do some sort of merge operation in SSIS, looking up values based on the PK and then updating or inserting. Not sure if you are worried about deletes.

    Any reason not to use replication to move data? How much data, how many tables need to move?

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

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