Solved

How to access a PostgreSQL database using SSIS?

Posted on 2011-02-26
3
1,493 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 500 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Learn about cloud computing and its benefits for small business owners.
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
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.

838 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