I'm trying to bulk load data into a postgres table which has a default value defined for the first column (id), using a sequence.
When trying to run the process, I get the following error immediately ;
[Devart PostgreSql Destination] Error: An exception has occured during data processing, the message returned from the provider is:
Column with name id does not exist.
However, if I change the target table so that the id column does not have a default value defined, the process runs.
The process also runs fine when set to a simple Insert.
I'm running the latest build of the Data Flow Components, Postgres version 9.6, and Integration services 2016.
Any ideas ?
Postgres: Error bulk inserting into a table with default column value
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Postgres: Error bulk inserting into a table with default column value
We have reproduced the issue with the Devart PostgreSql Destination component. We will investigate it and post the results here.