SSIS and postgres connectivity issue using .Net provider

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
vijayd
Posts: 2
Joined: Wed 22 Nov 2006 13:49

SSIS and postgres connectivity issue using .Net provider

Post by 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

Post by 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.

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by 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.

Post Reply