SAP Knowledge Base Article - Preview

1724254 - Merge for autocorrect not being used

Symptom

  • Data Services batch job with Autocorrect and Merge and Upsert checked on the target table does not appear to be merging records as expected.
  • SQL Server Profiler shows iterative entries of similar type:

    IF EXISTS
    (SELECT 1 FROM "DBO"."TESTIN"
      WHERE "DI_ROW_ID" = 63636 )
    UPDATE "DBO"."TESTIN" SET "NAMETEST" = 'test'   WHERE "DI_ROW_ID" = 63636
    ELSE INSERT INTO "DBO"."TESTIN" ("DI_ROW_ID", "NAMETEST") VALUES (63636, 'test')


Read more...

Environment

  • Data Services
  • MS SQL Server

Product

SAP Data Services 4.0 ; SAP Data Services 4.1 ; SAP Data Services XI 3.2

Keywords

DS , BODS , KBA , EIM-DS , Data Services , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.