• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1806
  • Last Modified:

How to access a PostgreSQL database using SSIS?

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
jbaird123
Asked:
jbaird123
  • 2
1 Solution
 
dbaSQLCommented:
0
 
jbaird123Author Commented:
Thank you - this helped.
0
 
dbaSQLCommented:
Good deal.
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now