FINALLY Got it to work! Found another thread entitled "Problem with running SSIS packages" that helped. Problem was my Oracle connection password would not save. It all...

Hmmm, I verified the software and tools are the same.

I also ran the package through Visual Studio on the server and it ran just fine.

The package...

Here is the error from the SSIS execution: 06/30/2008 13:21:05,Core OPS TRAMS Extract,Error,1,TRINIDAD-SQL\SQL1,Core OPS TRAMS Extract,Pull TRAMS Data,,Executed as user: NOAD\$sqlservice. ...n 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp...