Merge Statement
You might want to review parts one, two, and five of the video series on this page - part five deals directly with your issue. Talk to me now on
January 22nd, 2011 7:30pm

Hi All, I created a package previouly to load incremental data using some .net, as the scenario is to update the matching records by changing the indicator and then loading a new record for that record. And inserting new records for the non matching records. I was trying to use Merge Statement for this purpose but its throwing me an error that Insert statement cannot be used in When Matched Caluse. Is there any other way to handle it within the Merge Statement. Thanks Vineeshvineesh1701
Free Windows Admin Tool Kit Click here and download it now
January 22nd, 2011 7:46pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics