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 stringhttp://www.connectionstrings.com/ —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstuetze PASS Deutschland e.V. http://www.sqlpass.de)

---

You can use Link Servers to get the data —————————————-
http://dineshasanka.blogspot.com/

---

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

---

]]>