My fault...was unrelated problem: Ole won't load after reboot..
Coolberg: You rock, thanks for the reply.
Turns out it was an unrelated problem, one that I have been fighting for a year.
If I reboot some of our SQL Servers, then linked-servers or anything else that uses OLE-DB will fail, until someone goes to the console, and click on the tables under a linked server to get the ole drivers to load properly. Very strange. (must use console, cannot use TSE even.)
It turns out after I did this, the DTS job ran fine.
I've researched this, and cannot find much.
"Fight the Good Fight" -> Join NORML