cancel
Showing results for 
Search instead for 
Did you mean: 

Data Services Bulk load to SQL Server 2012

0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member220897
Participant
0 Kudos

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.