SQL Server Performance Forum – Threads Archive
DTS Job is FailingI 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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.