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

Postgres Composite Type issues

Post by satheesh » Thu 14 May 2020 04:04


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.

Site Admin
Posts: 8861
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.

Post Reply