Looks like it was an issue on the source server. I recreated the DTS job exactly and it failed the same way again.
I added an ORDER BY clause to the sql used to pull the data off the source server and it works now.
Not a very descriptive error coming out of DTS, but it's working now.
I still do not know why it would work when I manually ran it, but it wouldn't work when it was scheduled.
Live to Throw
Throw to Live
Will Summers