Post reply

Updating Two Values from a Temp table

  • July 15, 2020 at 12:35 pm

    #3770163

    I have a source table from Oracle db that needs to Update a SQL table, so i pull the source data via SSIS then write the data to a TMP table in SQL db

    The values i need to update are (Status and Response) using the batch id, source and destination table are identical

    See attached layout

     

    Attachments:
    You must be logged in to view attached files.

    It's better to fail while trying, rather than fail without trying!!!

  • July 15, 2020 at 12:58 pm

    #3770168

    Never mind i found the solution

    It's better to fail while trying, rather than fail without trying!!!

  • July 15, 2020 at 5:19 pm

    #3770301

    What was it? You might help someone else by posting it

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

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