Could you please help me to find out the ways whow to backup dts packages

The simplest form is to backup the msdb database, which you should be doing
anyway. Thsi assumes you are storing the dts packages in SQL Server itself.

An additional option is to open the package, and "save as" to a structured
storage file...but you would need to do them all individually.

Others here may have additional options....

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm


"Manas" <Manas (AT) discussions (DOT) microsoft.com> wrote

Try this it's free
SQLDTS.com
by Darren Green. Works just fine.

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Couldn't imagine a life without DTSBackup

Even used in an environment where the program was installed on server A to
transport packages from server B to Server C...!!


"steve hughes" <steve.hughes (AT) usa (DOT) net> wrote