Post reply

SSIS between Oracle and SQL Server

  • November 18, 2010 at 11:43 am

    #1252679

    I guess that when you read your data from the SQL Server table, that you have some sort of primary key.

    Use a multicast in your data flow and send all the primary keys to a staging/temp table.

    After the dataflow, use an Execute SQL task connected with the dataflow with an On Success precedence constraint (meaning that the Execute SQL Task can only run if the dataflow has run succesfully). In the SQL Task, update your source table using the primary keys.

    To be almost perfect: place the dataflow and the SQL Task inside a sequence container and set the TransactionOption to Required. This way, if the SQL Task fails, both will be rolled back.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • November 18, 2010 at 1:28 pm

    #1252728

    thanks for the hint, I'll try it at once!

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

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