Hey can you post the exact error that you receive while executing the job.
I used to have the same kind of issue .......it used to say ...teh file cannot be found and XML node an dpassword something.........
One thing make sure that on the server that fails, sql agent ( under which the jobs run) have all the rights that it needs to perform in SSIS.
ALos, make sure all the objects that SSIS is using u have on the server, and also enough permissions to do the work for sql agent.
My case was. one of the objcet was missing, and before runnning the job, it was trying to validate things, and thrwoing errors before executing the ssis.
Other time, sqlagebt had no enough permission to delete and archive files........
this was one of my error and if u look at the error it talks all about something............
Executed as user: ADHCSCINT\sqlagt. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:03:20 PM Error: 2008-10-16 16:03:20.68 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS
assword" with error 0x80070002 "The system cannot find the file specified.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2008-10-16 16:03:28.10 Code: 0xC002F304 Source: Rename and Archive flat file File System Task Description: An error occurred with the following error message: "Access to the path is denied.". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 4:03:20 PM Finished: 4:03:28 PM Elapsed: 7.547 seconds. The package execution failed. The step failed.
but the actual solution was to give enough rights to sqlagent to move, rename and delete files.