Devart Forums

We have a table in Postgres that uses an auto-increment on a UUID field. We tried to bulk insert into that table and exclude the field with the auto-increment and the bulk insert fails. What is the best way to handle this?

After some testing we were able to complete a bulkinsert into a test table with the same schema and column types. We think maybe the package has a schema issue. We are revisiting the original SSIS package. Thanks.

Can you confirm that the issue is solved?

Here is what the developer sent today. Can you confirm that this has to do with the destination component?

We are also testing some settings. Bulk insert uses text or binary setting, and also there is a Unicode setting that may effect the results. We have that set to false when I know we are using Unicode in the Postgres database.

So I just found out what the issue is with BulkInsert mode…it looks like when the Postgres data type is SMALLINT, the bulk insert fails because it’s trying to insert a NULL to the id column.

If I change the data type to INTEGER, the bulk insert works. I just tested this on the table changing the id column back and forth from SMALLINT to INT.

Looks like it’s a bug with their destination component.

We have reproduced the issue with a smallserial primary key. We will investigate it and post here about the results as soon as possible.

We have fixed the bug with Bulk Import into a PostgreSQL table with an empty value for a smallserial primary key. We will post here when the corresponding build of SSIS Data Flow Components for PostgreSQL is available for download.

New build of Devart SSIS Data Flow Components 1.10.959 is available for download now!
It can be downloaded from https://www.devart.com/ssis/download.html or from Devart Account (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=38889