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.