Solved

How to access a PostgreSQL database using SSIS?

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

910 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now