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.


This can be problem when you reading from excel as data table because there can be many formulas available so avoid write this into CSV file and then read as data table and add as Bulk insert and you will not get above error as columns are mismatch.

I tried it with a csv file but there was no difference. The data table actually has the same values and formats. The error message occurs both times.

When I use “insert” and not “bulk insert” it works. But it takes ages if you want to transfer large amounts of date. Therefore, I would like to use “bulk insert” but it is not possible.

Hi PeCour

Please check number of columns in the CSV and Database then check with Data types specially when you use read range check the data table in the Local during the Debug.

I have tried with SQL is working. You check DB connection is oky.