SAP Knowledge Base Article - Preview

1730898 - Error when loading table with identity columns


  • If number of loaders greater then 1 when loading a table with SQL Identity, the job will load first 1000 records from the 1st loader, however the 2nd loader will fail with Identity_Insert set to OFF error
  • It seems the Set Identity_Insert Table ON is only recognized by the 1st loader.
  • How to load a table with identity columns with Data Services?



Data Services 4.0


SAP Data Services 4.0


DS , BODS , BODI , DSXI , Edge , enhancement, parallel , insert , 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.