How to set up SSIS to extract data from Postgres Database

Question

I have a database PostGres database in the AWS Cloud. I would like to use SSIS to extract tables and move them over to a local SQL Server. Has anyone attempted to do this? Is it possible?

Ultimately I would like to move over tables from the PostGres to a SQL server, without having to purchase a tool.

Answer 1

As per the documentation, you would need to follow these steps to connect SSIS to a Postgres database:

• get the PostgreSQL ODBC driver, either with Stack Builder or using ODBC
• connect to PostgreSQL with the PostgreSQL ODBC driver (psqlODBC), using the proper connection string, typically Driver={PostgreSQL ODBC Driver(UNICODE)};Server=<server>;Port=<port>;Database=<database>;UID=<user id>;PWD=<password>