Hi all,

Connecting to a DB2 host the error is coming up 'Use does not have authority etc etc'

Here's the scenario.

BIDS test connection works fine.

I am using Package Configuration and have verified that the username and password in the xml are working.

I deploy the package via the deployment wizard.

Run the package and it fails with :

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANGER. <More blurb>

Then another error message 5 lines down:

"The user does not have the authority on the host resource"

I suspect the username and password are not being passed over.

I am at a loss. The xml config file definetly has the username and password in it.

Any help much appreciated.

TIA