SQL Server Performance

Save DTS Error!

Discussion in 'SQL Server DTS-Related Questions' started by Julio, Jul 27, 2006.

  1. Julio New Member

    Hi, I used to work whit several dts on my server, but suddendly, when I want to create a new DTS, and I save it, an error appears: "The directory name is invalid" and I can't save it at all, even if I change one.

    When I connect to the SQL server with another computer and I try to save the DTS it works, so I don't know what's happening.

    Thanks for help me!!!!
  2. dineshasanka Moderator

    Did you check the agent user permissions.


  3. Julio New Member

    Yes, we used to have a user and password, we think that the password expired, so we change it, but nothing, then we change to the system account, and nothing. At last we reboot the server and the problem was solved.

    Thanks a lot....

Share This Page