Im working on SSIS packages to populate a SQLServer Data warehouse from an I Series AS400 DB2.
Downoading data is no problem, using the ISeries IBMDA400 provider.
But I need to upload a couple od tables to the iSeries and then run a stored procedure to copy them into the prodution tables.
To do this I had to switch to the iSeries provider IBMDASQL. this runs fine when running in BIDS debug mode but when I save the package on the server and run it from a job, it dails with an invalid password on the connection.
I have tried this with, Protection level Server Storage, encrypt with password, and dont save sensitive, using a configuration table, in all cases it works fine running in BIDS, on the dev server, but runing as a SQLSERVE job on the same server it fails.
when I saved as Server storage i got the following from the job but it works from BIDS
Executed as user: Domain\XXXXXXXX. ...lity Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 7:38:53 AM Error: 2010-09-08 07:38:55.30 Code:
0xC0202009 Source: PJCMTest001 Connection manager "GroupQAC.RunProc" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.&
View Complete Post