Post reply

SQL to do a upsert or update/insert

  • March 17, 2008 at 9:55 am

    #790428

    Ah - SSIS makes all of the difference. I didn't catch the fact that it was in SSIS at all.

    By the way - have you checked this out yet? This is an article pretty much going over a good way to implement this , using SSIS. Andy is actually contributing on a book dealing with the nuts and bolts of SSIS, so this is a decent primer on it.

    http://www.sqlservercentral.com/articles/SSIS/62063/[/url]

    SSIS gives you a lot of options that involve objects/processes you don't see in T-SQL. If you want a t-sql based solution - Steve's solution would be the start to your process.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Viewing post 16 (of 15 total)

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