I'm trying to connect to a Postgres database via ODBC from SSIS. The odbc connection is defined on my PC and works perfectly with other applications, including Access. However, when I set up the connection in SSIS, everything appears to connect fine (test connection works, etc.) but when I look at the data connection in Server Explorer, there are no tables, no views, and no procedures. Also, the name of the data connection is ODBC.csidb. csidb is the name of the server where the postgres database resides, but the database name itself isn't showing up. Can someone please let me know what I'm doing wrong? Thanks!
Laurie
Further investigation has proved that I am, in fact, connecting successfully to the database but for some reason the metadata is not being shown. Any ideas?|||Can you repro the same problem elsewhere? (i.e. not in SSIS)
-Jamie
|||No, I can't. It works in other places.
No comments:
Post a Comment