ssis connecting to postgresql error - unknown host

Question

Hi All,
I followed the below link step by step to connect to PostgreSQL source in my SSIS Package and I am getting the below error
"could not translate host name 'abc.com:5432/database?' to address unknown host.
I tried looking online with out any solutions
https://dataqueen.unlimitedviz.com/2012/07/ssis-connect-to-postgresql/
I can connect to the PostgreSQL using sql developer and I cannot using the same credentials.
Please advice
Thanks

Answer 1

@ZoeHui-MSFT thanks, yes I installed every thing , i get the errors when i enter the credentials in the ODBC Administrator. I can connect using SQL Developer
Thanks

Answer 2

Hi @Amy Jandreau ,

Have you configured ODBC for both 32 and 64 bit applications?

Here is a detailed tutorial about configuring ODBC drivers instructions for PostgreSQL and connect it via SSIS.

You may have a double check to see if you have missed any steps.

ssis-with-postgresql-connect-to-postgresql-with-ssis-components

INSTALLING AND CONFIGURING POSTGRESQL TUTORIAL

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.