Damn it, I had it setup as a user DSN not a System DSN, uhhh I'm so stupid. Thank you very much for pointing me in the right direction!!!!

It has an ODBC connection, but I use a different account to create that ODBC connection...Hmm but anythings possible at this point, I'll check it out.

SQL Agent Job with a type of cmdexec

Yes I make a remote desktop connection to the server and for whatever reason that fixes it, very odd. I don't know how...

I'm having a similar problem but I'm receving the following error. I'm doing to the same as the original poster moving from SQL 2000 to 2008. I have other jobs...