Hi All,

Here's a simple question (with probably a simple answer):

I will be reformatting one of my SQL boxes this weekend, but I need to move
all databases, jobs and DTS packages from it to the other SQL box. Is there
any way to export or move a DTS package from one SQL server to another? I
was able to move my jobs by generating and SQL script for each, but I can't
find a simple way to move DTS packages.

Thanks!

Brian.

Well I know of one way. I don't know if it's the only way or best way. Any
way... here it is.

Open the dts package, then click on the menu item "Package - Save As..."
In the dialog box that pops up there is a field called "Server" which lets
you select another server to save it to.

Kevin

"Brian Piotrowski" <bpiotrowski (AT) NOSPAM (DOT) simcoeparts.com> wrote

Hi,
Try this http://www.sqldts.com/default.aspx?272
DTS Backup 2000
A great tool.