0

I am working on SSIS and get trouble with POSTGres. Because I need to build a command text from variables, so that I have to use the Ole DB Datasource to retrieve data from a Postgres server. I have search alot pages in internet but not found any good provider (it is not reasonable with fee granted tool such as Devard :(, Postgres is free, it's drivers and provider should be free also). Does someone can give me a hand on this?

Thanks

Improve this question
3
  • 1
    Are you sure that you need to use an OLEDB provider? Have you tried using an ODBC data source with the (free) PostgreSQL ODBC driver? Commented Nov 16, 2016 at 20:41
  • You may be interested in the answer here. Commented Nov 18, 2016 at 15:16
  • Hi Gord, yes, I need Ole DB for building dynamic queries. ODBC data source not support to build query from variables. Commented Nov 19, 2016 at 4:13
Related questions
0
How to configure SSIS 2005 OLE DB data source component to use sql query from external file?
3
Creating a connection from Microsoft SQL server to an AS/400
0
SQL server SSIS OLEDB source to destination?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.