BulkInsert Fails With Column Data Type Mismatch

Resolution for the operation Bulk insert: The provided columns in the DataTable do not match the column data types in the database.

Issue Description: The Bulk Insert activity is used in the context of an Oracle database connection.
The Oracle Manage Access driver is used to connect to the Oracle database.




Error message: The provided columns in the DataTable do not match the column data types in the database.



Root Cause: This is because the Oracle database kept Integer values as a number type:



Resolution:

  • Set the column in the Data Base as decimal.