Data Services Bulk load to SQL Server 2012

former_member231540 — Tue, 15 Nov 2016 19:57:45 GMT

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.

Re: Data Services Bulk load to SQL Server 2012

former_member220897 — Fri, 18 Nov 2016 08:29:52 GMT

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.

Question Re: Data Services Bulk load to SQL Server 2012 in Technology Q&A

Data Services Bulk load to SQL Server 2012

Re: Data Services Bulk load to SQL Server 2012