Post reply

Import/Update From a Single File

  • February 21, 2008 at 11:29 am

    #120024

    I'm trying to figure out the best way to handle an import. I have a single flat file that contains both new records and updates to current records in a single table. I am matching on a GUID. I was wondering if there is a best practice for this. I've scowered google and msdn for a recommended solution (I can think of many, but most of them involve looping) and not found anything but I may just not be searching for the right thing. Does anyone have any advice or can you give me a nudge in the right direction?

    Thanks in advance.

  • February 22, 2008 at 9:37 am

    #781167

    I found a solution.

    http://www.sqlis.com/311.aspx

    I add an "Existing Rows" to the output of the Conditional Split for records that exist and perform an Update. Please let me know if anyone knows of a more efficient method.

    Thanks!

Viewing 2 posts - 1 through 1 (of 1 total)

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