SSIS Package(File to Postgres Load) Execution Error: there was error trying to establish ODBC connection with DB server

userAnym 0
Viewed 23

I created a SSIS package for a simple file to Postgres table load. In Visual Studio it ran without any issues. But when its deployed and ran via SQL Agent job its failing stating below error:

enter image description here

as per the answers I found here and on other sites, I have changed the VS version to lower then the SSIS and changed the runtime to 32 bit in both the places. But its still failing due to the same error. so any suggestions would be of great help and let me know if you need more details, thanks!

ScreenShots:

  1. SSIS Package:

enter image description here

  1. Package deployed in SQL Server:

enter image description here

  1. SQL Agent Job:

enter image description here

odbc ssis visual-studio sql-server postgresql
0 Answers
Related