var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SSIS problem:Package connection error to DB2 host
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.