Hi,

I am a local admin on this box. I can excute DTS package manual without any errors. But, when I schedule it to run, I will get the follow error. anyone know how about I can fix it? I am login to the machine all the time. I don't underatnd why it's trying to use anonymous logon when running the DTS package .

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Unable to connect to source server for Transfer. (Microsoft SQL-DMO (ODBC SQLState: 28000) (80004005): [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.)
Step Error code: 80040443
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:5700

Just in case anyone is having the same problem and looking for a solutions too. I found a post on web with solution to this problem. There's a secction in SQL Server Agent, connection, where you can type in a login. I am not 100% sure if that's what it uses. But I tested myself changing the user that started agent works. I used a different user to start SQL Server Agent and it solved my problem. So if you are running out of methods, might give it a try. good luck.