Close connection with SSIS

Hi

Im using pgnp 1.4.0 version.

When the transaction is completed,
the connection is remained with IDLE status.

In forum I found that the same issue was fixed
( http://www.pgoledb.com/forum/viewtopic? ... connection ).
How can I close the connection
when the transaction is committed?

Thanks.

This could be related to the default OLEDB connection pooling. Please check that the connection gets closed after 2 minutes. If connection is closed after the timeout and you want to disable the behavior, configure OLEDB_SERVICES registry key to disable the pooling.

If connection never closes, it could be a bug. Please e-mail us details on how to reproduce the issue.

Thank you!

Thank you for reply.

But I could not find pooling information about OLEDB_SERVICES key in reg editor.

Show me the full key name or other place to set for pooling.

Regards,
Changbai

For Postgres and Greenplum providers (PGNP): HKEY_CLASSES_ROOT\CLSID\{3170DFF1-4803-42a0-A1B3-D14656857071}

For Redshift provider (RSNP): HKEY_CLASSES_ROOT\CLSID\{FFCCB099-E3D0-4FFC-87F9-AC3FAAF91271}