SSIS and postgres connectivity issue using .Net provider

SSIS and postgres connectivity issue using .Net provider

Postby vijayd » Wed 22 Nov 2006 13:53

Unable to connect from Sqlserver Integration services to postgres using PostgreSQLDirect .Net provider

Can anyone shed some light on this issue?

Error: Object reference not set to an instabe of an object

Thanks
vijayd
 
Posts: 2
Joined: Wed 22 Nov 2006 13:49

SSIS and postgres connectivity issue using .Net provider

Postby vijayd » Wed 22 Nov 2006 14:27

it is working now. I had to force the connection to specific database and schema instead of it showing the available databases from drop down list and selecting one.

Not sure why this is happening but since it is connecting i am ok for now.

Thanks.
vijayd
 
Posts: 2
Joined: Wed 22 Nov 2006 13:49

Postby Alexey » Thu 23 Nov 2006 08:00

Please note: we are not fully support integration services. It will be added in a future versions of PostgreSQLDirect .NET.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for PostgreSQL