July 19, 2002 at 11:53 am
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
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
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply