wa***********@us.scorex.com (Warren Wright) wrote in message news:<84**************************@posting.google. com>...
I have production SQL Server database that must be moved to a new
machine. There is a fairly complex DTS package on the original server
that is used to handle the weekly updates to the database.
Is there a way to export this DTS package in order to set it up on the
new machine as well?
Best Regards,
Warren Wright
Scorex Development Team
You can, when designing the DTS Package, select "Save As..." and
change the "location" to a structured storage file. You can then
import this file onto your production server. If you scripted all
your local connections as "(local)", then this should be the end of
the story, if not, you'll need to open it and change your local
connections to the production server.
Hope this helps
Hodge