Hello,

I have to migrate database from one server to another, moving database is
easy part and all set for that. I have about 40 DTS package running on server
and wanted to migrate all DTS to new server ..

My problem ..

1 ) Is there any way I can copy all DTS packahe to target server ?
2) How can I also copy all my schedule job ?
3) Do I need to change manually Server connection property as server name is
changed ?

Thanks
-Kris

Take a look at the following article:
Transferring DTS Packages
http://www.sqldts.com/default.aspx?204
You can script out jobs from Enterprise Manager or use
SQL-DMO and the script method. If scripting works for you
depends on how you created the jobs - if you used the
Schedule Package functionality or created your own dtsrun
step in the job, what authentication, login you used when
creating the jobs, etc.
Yes you would need to change server name references if they
have changed and you aren't using (local)

-Sue

On Wed, 25 Aug 2004 15:33:05 -0700, "Kris"
<Kris (AT) discussions (DOT) microsoft.com> wrote: