Post reply

DTS Packages

  • July 19, 2002 at 11:53 am

    #158612

    I need to move DTS Packages to a remote server behind a firewall. I backed up a copy and restored it on the server. But now i need to move one new Package and not all of them. I made a route to the remote server but it still doesnt recognize it. also is there a way to back up only 1 package or move it to a VB file and restore it on the remote server as a package.

    Thnx

  • July 19, 2002 at 12:51 pm

    #433121

    Do a "save as" and choose structured storage file. This will give you a .dts that you can copy to the remote server and then "open" it in EM. Then you can save it.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply