In a previous post I was asking about a performance difference between an
SSIS package compared to a DTS package it is intended to replace. The
difference on a 2 million row table was 12 minutes (DTS) versus over an hour
(SSIS).

In further testing it appears to be the actual query from the source AS400
that is slower so I though I would try replacing the ODBC connection with a
connection using one of the three OLE DB providers that we have for the
AS400.

I can set up a connection using one of these and it will "Test" okay, but
when I try to switch to this connection in my OLE DB source object I get the
following error...

Error at Extract FRNHNT021 O6P [Source - Query [1]]: Cannot acquire a
managed connection from the run-time connection manager.

Searching the web on this error has not produced much. Can anyone tell me
what I need to look for? I'm wondering if it has to do with the fact that
the password for the user profile is not being retained. I have checked the
box to "allow saving password", but this appears to make no difference.
Whenever I open the connection properties the password has been removed.

TIA