I am trying to import a table from PostgreSQL to SQL Server. One of the fields in the Postgre table is "bytea" data type. When I open the table in dBeaver, that column contains json data.
I created an ODBC system user that connects to PostgreSQL for SSIS. When I viewed the table data using SSIS ODBC Source, it shows encrypted data for that field. After the data was imported to SQL Server table varbinary(max) column, it contains the encrypted data. I cast the data to varchar(max) "cast([bytes] as varchar(max))". It returns "’", no json data.
My question is
(1) Why SSIS ODBC Source shows encrypted data instead of the original json data?
(2) What has to be done in order to bring in the original json data?
Thanks.
Dany