Skip to Content
1
Former Member
Apr 22, 2014 at 02:00 PM

BODS Error with IDENTITY INSERT and Transactional Data Loading

1918 Views

Hi All,

We are facing some issues while working with SAP BODS,

Scenario: We have 4 tables in Microsoft SQL Server that contains identity Columns and they bears an Parent-Child Relationship among themselves.

We need to insert values into the tables simultaneously.

Solution we are trying to implement:

a) Trying Transactional Options for each table in the data store – but for that the preloading and post loading SQL tabs are going disabled

So error facing is enable identity_insert is set to OFF. We have everything enabled in database the user which connects the BODS is the owner of the database.

b) Trying Bulk Loading Options

Bulk Loading is able to insert values into tables, but then where there is a parent child relationship we are facing the error of Foreign-Key.

Please Share your views.

Thanks a lot in advance.

Regards

Joy