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.
Postgres Composite Type issues
Re: Postgres Composite Type issues
We have reproduced the issue and are investigating it. We will notify you about the result.
Re: Postgres Composite Type issues
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.
Re: Postgres Composite Type issues
Devart SSIS Data Flow Components v1.13 are released: viewtopic.php?f=60&t=41242.