So the problem appears to be in the DTS package itself and not in the job calling the package.

To view the DTS log, right click the DTS package that has...

I have a bunch of DTS packages running nightly from SQL Agent that work fine but I have had problems in the past. Some problems I have had have been:

1....

If you are setting up a new server as a copy of the old server there is another way of moving jobs, alerts, operators and DTS packages. Backup the MSDB...

Thanks for your views on this, I haven't been thinking about how Yukon will affect this.

The more I look into it the more I think the 2000 would be more...