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

Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Post Reply
valthor
Posts: 6
Joined: Fri 25 Aug 2017 00:34

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

Post by 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 ?

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

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

Post by 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.

Post Reply