Solved

How to access a PostgreSQL database using SSIS?

Posted on 2011-02-26
3
1,542 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help  needed 3 52
SQL Error - Query 6 54
AD account Auto logoff 1 56
Ideas on migrating very large  system from SQL 2005 to SQL 2014 3 40
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
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…
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.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

739 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