Symptom
- 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?
Read more...
Environment
Data Services 4.0
Product
SAP Data Services 4.0
Keywords
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.