I'm not sure this is your problem or not, but I had a similiar issue where the DTS runs manually just fine, but not as a Job.  Here's what someone...

The question was:

Bill is busy working on a report for the CFO. This report shows sales generated by month over the last year and aggregates them to show the totals...

I'm sorry, maybe I missed it, but was there a question here?  It appeared that the question was not fully formed.

"You need to move a virtual instance of SQL server...

Lee,

I tried your query, but got no records returned. Even running just the first line of SELECT T1.* FROM dbo.sysdtspackages got NO records. I'm on the MSDB...