Postgres: Error bulk inserting into a table with default column value

Postgres: Error bulk inserting into a table with default column value

Postby valthor » Fri 25 Aug 2017 00:43

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 ?
valthor
 
Posts: 1
Joined: Fri 25 Aug 2017 00:34

Re: Postgres: Error bulk inserting into a table with default column value

Postby Pinturiccio » Tue 29 Aug 2017 10:58

We have reproduced the issue with the Devart PostgreSql Destination component. We will investigate it and post the results here.
Pinturiccio
Devart Team
 
Posts: 2025
Joined: Wed 02 Nov 2011 09:44


Return to SSIS Data Flow Components