Postgres Composite Type issues
Posted: 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.
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.