Skip to Content
avatar image
Former Member

Data Services Bulk load to SQL Server 2012

Hi All,

We are loading data from BW to SQL server 2012 using bulk load option.

Environment

  • Source: BW Openhub
  • Target: SQL Server 2012

When we load the data first time (target table is empty) it's loading without any issue and when we try to load delta in to the same target table using bulk load option we are getting below error and not allowing to overwrite data.

Also we observer 'Auto correct load' option is disabled when we select 'bulk load option'.

Can any one have similar issue or solution for the issue which we are facing now .

Appreciate if you can provide resolution steps or sap documentation.

Thank You,

Phanikumar.

error.jpg (678.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 18, 2016 at 08:29 AM

    That's right, 'Auto corect load' and 'Bulk load' are mutually exclusive modes. And Bulk load actually always performs inserts and no updates. So either disable bulk load and enable 'Auto corect load', or cleanup the corresponding keys from your target table in a previous workflow step. You might also choose to bulk load into an intermediate empty table and then run a MERGE SQL command.

    Add comment
    10|10000 characters needed characters exceeded