Hi,

I have many DTS packages created on a Server. I am now planning to
shift the SQL Server Database on a new higher capacity server.I want
all the packages those are there on the current server to be available
on the new server.
How can I achieve this? Can I generate scripts for these packages as I
do for any database object or login?

Thanks in advance.
Rohit

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/DTS-Generate...ict249891.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=865265

There are a number of ways to do this and one of the simplest would be to
Export msdb.dbo.sysdtspackages to a text file and then reimporting at the
other side. Another would be to restore MSDB at the other side.

Have a look here

Transferring DTS Packages
(http://www.sqldts.com/default.aspx?204)



"Rohit" <UseLinkToEmail (AT) dbForumz (DOT) com> wrote

http://www.sqldts.com/default.aspx?204

--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

"Rohit" <UseLinkToEmail (AT) dbForumz (DOT) com> wrote