Page 1 of 1

SSIS and postgres connectivity issue using .Net provider

Posted: Wed 22 Nov 2006 13:53
by vijayd
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

SSIS and postgres connectivity issue using .Net provider

Posted: Wed 22 Nov 2006 14:27
by vijayd
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.

Posted: Thu 23 Nov 2006 08:00
by Alexey
Please note: we are not fully support integration services. It will be added in a future versions of PostgreSQLDirect .NET.