DTS Job is Failing | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS Job is Failing

I have made a DTS Package, I have scheduled this package. The scheduling has created a job. When I run this job manually, it gets failed with error The job failed. The Job was invoked by Schedule 15 (TransferUsers). The last step to run was step 1 (TransferUsers). Please guide me how to resolve this issue, so as the job may execute successfully
The job runs in the context of the SQL Agent account. The DTS package runs in the context of whatever user executes it. It’s most likely an NT permissions issue for the network file.
KBAhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074 for more insight. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>