Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2003
    Posts
    10

    Unanswered: Getting DTS packages back from a backup?

    Does anyone know how to get a DTS package back into the EM's Local Packages from a disk backup?

    In other words, inside Package Designer, it is possible to save a package to disk as a .dts file.

    But, if the package has been removed from the EM Local Packages, I don't see any way to get the package imported back in from the backup file on disk.

    The import/export wizard seems to be for moving a package from one database to another. I don't see anything that stands out as a way to read a 'flat' file from disk.

    Anyone know how this is done? (I assume it can be done, else, why provide a way to save a package out to disk in the first place?)

    Thanks much.

    Randyvol
    randyvol
    <>< "what we do in life echoes in eternity"

  2. #2
    Join Date
    Feb 2004
    Posts
    10
    When you are looking at a server in EM highlight the treeview item "Data Transformation Services".

    Right click to bring up the popup menu.

    Click on the "Open Package..." item.

    In the "elect File" Dialog box select your file.

    Your package is now open in the designer...save it to the server.

    Hope this helps...

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Are you talking about a database dump

    DTS packages are store in master, not the database they act against.

    If not that then what?

    Did you save a DTS Package as a visual basic file or Structure storage file?

    Step be step tell us what you have , what you did...I'm guessing you want the package available again to the server...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Feb 2004
    Posts
    10

    Question

    Originally posted by Brett Kaiser
    Are you talking about a database dump

    DTS packages are store in master, not the database they act against.

    Brett, I thought DTS was stored in msdb database, not master. Was this a change between SQL server 7 and SQL 2k?

    <<this is an aside to the actual thread>>

    Thanks!

  5. #5
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Originally posted by Brett Kaiser
    Are you talking about a database dump

    DTS packages are store in master, not the database they act against.

    If not that then what?

    Did you save a DTS Package as a visual basic file or Structure storage file?

    Step be step tell us what you have , what you did...I'm guessing you want the package available again to the server...
    It was joke, wasn't it ?

  6. #6
    Join Date
    Dec 2003
    Posts
    10
    Originally posted by 93fd3s
    When you are looking at a server in EM highlight the treeview item "Data Transformation Services".

    Right click to bring up the popup menu.

    Click on the "Open Package..." item.

    In the "elect File" Dialog box select your file.

    Your package is now open in the designer...save it to the server.

    Hope this helps...
    KUEL - you grasped my question 100%. As I said the package had
    been saved off to a disk as a structured file (.dts file) and I couldn't
    figure out how to get it read back in.

    This works !! Thanks.
    randyvol
    <>< "what we do in life echoes in eternity"

  7. #7
    Join Date
    Feb 2004
    Posts
    10

    Thumbs up

    I am glad I could help. We just went through a long debate at my company on whether we should export DTS packages as .bas or .dts. We felt that for the primary purpose of restoring a deleted package, the .dts file worked better (was simpler). So this is our standard procedure for restoring a package to the server.


    Yea! I helped someone, I helped someone!


Posting Permissions

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