Results 1 to 4 of 4

Thread: DTS not saving

  1. #1
    Join Date
    Oct 2005
    Location
    Ireland
    Posts
    92

    DTS not saving

    When I open a DTS package, save it as a bas file, make changes, close the package and save it when prompted, where are my changes saved?

    The answer appears to be nowhere. When I reopen the package it's back to it's original setup. When I check the bas file it's as it was when I originally saved it.

    Any ideas? Like where my mornings work is gone?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Should save change before closing it.

  3. #3
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Did you open the package that is saved in SQL server?. If you saved the package in BAS file, then you need to go to File menu in DTS designer and open the file.

  4. #4
    Join Date
    Oct 2005
    Location
    Ireland
    Posts
    92
    No, I opened the bas file directly.

Posting Permissions

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