Post reply

How can I update original Ole DB Source after Multicast?

  • July 17, 2008 at 10:53 am

    #122413

    Requirement: I have a flat table that I need to split into many tables, and then timestamp (basically confirming the extract was completed) the original source table after the multicast inserts take place.

    I am able to split everything out just fine...I just can seem how to figure out what to use to update the original table in the most efficient manner.

    Any help would be greatly appreciated. 🙂

    Thanks,

    Bonnie

  • November 7, 2018 at 8:18 pm

    #2012770

    Even i am searching for same. not getting. instead of update i need to delete from source table

  • November 7, 2018 at 10:08 pm

    #2012774

    Is this an SSIS question?
    Why not just use a DELETE/TRUNCATE statement on the source table after the insert, maybe inside a transaction?

  • November 9, 2018 at 10:25 pm

    #2013051

    Note this is a ten year old post 🙂

    timestamp (basically confirming the extract was completed)

     

    I dont see the difficulty here though in theory. Have a datetime field named like record_extracted_timestamp.
    Use a procedure to split the data to the multiple tables. Once the blocks that insert the data into the target tables completes....have another  block of code there at the end that goes to the source table and updates record_split_timestamp field with getdate() for instance.

    ----------------------------------------------------

  • November 13, 2018 at 6:23 am

    #2013308

    "Note this is a ten year old post :)"  

    I know!  Imagine my surprise when I saw the email notifying me of new responses.

    MMartin1 - Friday, November 9, 2018 10:25 PM

    Note this is a ten year old post 🙂

    timestamp (basically confirming the extract was completed)

     

    I dont see the difficulty here though in theory. Have a datetime field named like record_extracted_timestamp.
    Use a procedure to split the data to the multiple tables. Once the blocks that insert the data into the target tables completes....have another  block of code there at the end that goes to the source table and updates record_split_timestamp field with getdate() for instance.

  • November 13, 2018 at 10:22 am

    #2013358

    I can imagine :). I get those as well on posts I did a long time ago. Surprise.!

    ----------------------------------------------------

Viewing 6 posts - 1 through 5 (of 5 total)

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