Bulk Insert Error

Plazio Michele

Hi Community,

Does anyone have any clue about this error message which pops up when I'm running a Bulk Insert step on a procedure?

Bulk insert to SQL Table

Comments: Exception has been thrown by the target of an invocation. [CorrelationID: 5623b57f-c8f8-44a1-a6c2-bbaeb0bc0899]

Does it depend on some functional feature of the table I am trying to do the INSERT INTO such as the presence of a primary key?

I do not experience any issues if the table is emptied just before writing into it with the same Bulk Insert step.

Thank you for your help!

Plazio Michele

Thank you for your reply!
The table had a primary key on a field which identifies the month and we run the procedure containing the Bulk Insert step two times selecting a different month for each execution of the procedure, thus there should not be any duplicated records.

We solved it by removing the primary key from the table and ensuring the absence of duplicated record in the procedure just before the Bulk Insert step.