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.

GMB · Accepted Answer · 2019-09-09 23:24:44Z

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>

answered Sep 9, 2019 at 23:24

GMB

224k25 gold badges103 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hadi · Accepted Answer · 2019-09-10 19:24:33Z

1

You can use the Postgres OLE DB Provider to connect to Postgres using OLE DB Source. The following link contains a step by step guide to import data from Postgres into SQL Server:

Export data from Postgres to SQL Server using SSIS

answered Sep 10, 2019 at 19:24

Hadi

37.5k13 gold badges73 silver badges128 bronze badges

Collectives™ on Stack Overflow

How to set up SSIS to extract data from Postgres Database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related