Get data from Postgres database | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Get data from Postgres database

How do I get data in my table in SQL Server from a Postgres table
If there is an OLEDB or ODBC driver for Postgres, you can find here the appropriate connecion string —
Frank Kalis
Microsoft SQL Server MVP
Heute schon gebloggt?
Ich unterstuetze PASS Deutschland e.V.
You can use Link Servers to get the data —————————————-

or Use DTS Madhivanan Failing to plan is Planning to fail
I want to use a DTS to get this job done.As this has to be scheduled.
I am using Other Connection. Data Source (Other ODBC Data Source).
Asks for User or File DSN. How do I go about now.
Have 0 knowledge of Postgres. ~Rosh