?
Solved

How to access a PostgreSQL database using SSIS?

Posted on 2011-02-26
3
Medium Priority
?
1,849 Views
Last Modified: 2012-05-11
What is the best tool to use for accessing a PostgreSQL database using SSIS (2005)?

It looks to me like SSIS does not support ODBC, and I have tried the OLE DB program from http://pgfoundry.org/projects/oledb/ without any luck (I can't connect to the database with that driver and it appears to be 5 years old so I am skeptical about it).

I am running Windows Server 2003.

I have also tried this tool:  http://pgoledb.com/index.php?option=com_filecabinet&view=files&id=1&Itemid=68  and I can connect to the database, but I can't see any tables with this tool.  It is also not free - which is what I would prefer if possible.  However, I would be willing to pay for a driver that really works.
0
Comment
Question by:jbaird123
  • 2
3 Comments
 
LVL 17

Accepted Solution

by:
dbaSQL earned 2000 total points
ID: 34988063
0
 

Author Closing Comment

by:jbaird123
ID: 35019154
Thank you - this helped.
0
 
LVL 17

Expert Comment

by:dbaSQL
ID: 35019736
Good deal.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

568 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question