Thank you for the reply. Yes, I have looked at the job step detail where the DTS task bombs. Here's the tail-end of it:"DTSStep_DTSDataPumpTask_16; 5000 Rows have been transformed...

Had this problem as well. Try running the server with no one logged in. Authentication will then occur using the credentials that were used when the server...

Here's one I use:

USE master

BACKUP LOG Vision WITH NO_LOG

GO

Use MyDatabase

DBCC SHRINKFILE(MyDatabase_Log)

GO

Check out this article in the Microsoft Knowledge base: Q268413. It fixed our problem with the SSPI error.