Postgres Composite Type issues

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
satheesh
Posts: 1
Joined: Wed 13 May 2020 23:57

Postgres Composite Type issues

Post by satheesh » Thu 14 May 2020 04:04

Hi,

I'm new to postgres and also SSIS . I have added new DevartPostgresSqlDestination for a transformation. There is a column in my table of "Address" composite type. I'm not able to see the column in the column mapping. When i click refresh in the Advanced Editor it shows error "Error data flow task.... The data type of the column "Address" is not supported for the component.

When i tried the same with PG ODBC driver it shows the address column in the destination and I used derived column in SSIS to map to my destination in ODBC.

I'm not sure what i'm missing here. Any help would be appreciated. Thanks in advance.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Postgres Composite Type issues

Post by Shalex » Sat 23 May 2020 19:14

We have reproduced the issue and are investigating it. We will notify you about the result.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Postgres Composite Type issues

Post by Shalex » Thu 28 May 2020 12:48

The composite data types are supported (PostgreSQL). The internal build with the fix is available at https://download.devart.com/devartssis_1_12_1207.exe.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Postgres Composite Type issues

Post by Shalex » Sat 20 Jun 2020 15:56

Devart SSIS Data Flow Components v1.13 are released: viewtopic.php?f=60&t=41242.

Post Reply