Bulk Insert

Help Studio
1

Hi Team,

I have a bulk insert activity to upload data however not all data gets uploaded to database.

I have done the following to mitigate the issue:

  • Re-ordered the table to ensure it gets uploaded in the correct order.
  • I have removed any spaces in the data
  • I have made sure the data that was going in was the correct dataTypes.

But still the bulk insert does not work.

2

Hey @Aki1111,

This issue may occur due to hidden special characters, constraint violations, or mismatched column mappings during bulk upload. Please validate the DataTable schema against the database table structure and ensure no nulls or constraints are violated. If the issue persists, enable detailed logging or use the “ContinueOnError = False” property to identify the exact failing records.

3

I did that, but it does not throw an error or gets inserted.