I have a dts package on dev. server, what are the diff.
ways I can move this to production box.

Thanks in advance

If this is only one, then the easiest way is to open the package in the designer and save as

If you are connected to the target server, set the location to SQL Server and fill in the information for that server

If you are disconnected, then save to Structured Storage file. Save the file. Move the file to the server, then click open package in the DTS packages node in Enterprise Manager. Then save to SQL Server

Russ

Thanks Russel.


that server.
click open package in the DTS packages node in Enterprise
Manager. Then save to SQL Server.