Results 1 to 2 of 2

Thread: DTS package fails

  1. #1
    si Guest

    DTS package fails


    I set up a DTS package to run every night on my SQL 7 Server.
    It is supposed to write a text file of modified rows every night.
    It was working fine until I changed the password for sa, now it
    fails. Also in Enterprise Manager, when I try to look a the package
    properties, I get a "login failed for user sa" package error.

    What to do?

  2. #2
    si Guest

    changed password causes DTS package to fail




    ------------
    si at 9/2/99 6:57:03 PM


    I set up a DTS package to run every night on my SQL 7 Server.
    It is supposed to write a text file of modified rows every night.
    It was working fine until I changed the password for sa, now it
    fails. Also in Enterprise Manager, when I try to look a the package
    properties, I get a "login failed for user sa" package error.

    What to do?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •