• 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]

    ____________________________________________________________

    AP