I have more than 35 DTS packages which needs to be deploy on one of the new server. Can anybody tell me is there a way, so that I can deploy such packages from source server to destination server in a single run?
What I found is, Save As all packages on source server in SQL Server so that I can develop a new package to transfer these packages from source's msdb..sysdtspackages table to destination's msdb..sysdtspackages.
I haven't tried it yet, can anybody explain, is this a way to deploye bulk DTS packages from one server to another server in a single run?
Thanks in advance,