Wednesday, March 7, 2012

dts package

I have about 30 dts packages created for different databases . I am rebuilding this server. How do I move the dts packages, I need to back them up into another server. And then restore and re-install them when the server is rebuilt. How do I back up and restore dts packages.
Pls helpOriginally posted by dokeyemi
I have about 30 dts packages created for different databases . I am rebuilding this server. How do I move the dts packages, I need to back them up into another server. And then restore and re-install them when the server is rebuilt. How do I back up and restore dts packages.
Pls help

You could save it as files
or you can also backup all your databases included master and msdb and restore on your new server|||Originally posted by omiossec
You could save it as files
or you can also backup all your databases included master and msdb and restore on your new server

You mean save the files one by one individually? How about deploying them? Say I have 100 ++ DTS packages?|||Check out www.sqldts.com. Look in their downloads section for something called DTSBackup2000. I have used it in a development environment with a tremendous amount of success. I have not yet had the courage to try it in production, but I'm getting pretty close.

Regards,

Hugh Scott

Originally posted by dokeyemi
I have about 30 dts packages created for different databases . I am rebuilding this server. How do I move the dts packages, I need to back them up into another server. And then restore and re-install them when the server is rebuilt. How do I back up and restore dts packages.
Pls help

No comments:

Post a Comment