There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server

153 Views Asked by At

Please help, as I can not seem to upload/insert data from my SQL Server to my SSH Postgre and I get this error:

There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server

I checked the connection using SSMS and a program I designed and they work fine using the ODBC but SSIS is not working.

Inserting data into PostgreSQL using SSIS and ODBC.

0

There are 0 best solutions below