locked
SSIS Delete/Insert/Update RRS feed

  • Question

  • I am still learning SSIS.

    What is the best way to do delete/insert/update in a database in SSIS. I am looking to achieve something similar to what was there in a Data Driven Query in SQL Server 2000. I would like to delete/insert/update the destination table based on the condition that my lookuptable returns

    For ex

    If "the user in my source table has changed the status"  Then

     Update the user row in the destination table

    Else skip the row

    If "the user in my source table has delete flag =1 "  Then

    Delete the user in the destination table

    Else skip the row

    If "the user in my source table is new(has a new ID)  "  Then

    Insert the user in the destination table

    Else skip the row

     

     

     

    Any suggestions ....

    Cheers

    Siaj

     

    Monday, March 20, 2006 8:53 PM

Answers

All replies