Home Forums SQL Server 2008 SQL Server 2008 - General SSIS to import and update data if exist on the destination RE: SSIS to import and update data if exist on the destination

  • May 26, 2015 at 1:54 am

    #1800488

    Anshul.P (5/26/2015)

    Here is one more option which you can use.

    Using Merge in SSIS -

    https://itssmee.wordpress.com/2010/10/03/ssis-insert-and-update-rows-in-a-table-based-on-the-contents-of-a-excel-file/[/url]

    Just be careful when using Ole DB Command as it processes a single row at a time, something like cursor.