Thanks for all the help guys. I was googling and found this site which helped explain the route you all were suggesting. There is also a free tool for download called DTSBackup. Its very easy to use
Like Tara said in her first post ( I never missed seeing it earlier too) can this not be done by just the export of sysdtspackages table in msdb database? for future use, the back up of just the table can be stored in a temp table or in an excel sheet and then restored to the sysdtspackages table of the destination server if there are concerns for restoring the whole database (msdb). Or is there any reason why we need the whole db backed up that I am missing? Pls. enlighten.
Also, there is this very useful site and deals with transfering DTS packages. http://www.sqldts.com/
Or is there any reason why we need the whole db backed up that I am missing? Pls. enlighten.
MSDB is a system database that needs to be backed up regularly. It does not only contain DTS packages. It also contains your jobs, operators, and alerts (jobs being the most important).
Hi, Just a quick post on this topic. Did you try running the package in Query Analyser like this: usp_SavePackages 'E:\DTSBACKUPS\' the \ at the end of the folder name is essential to the code working. If you run it like this: usp_SavePackages 'E:\DTSBACKUPS' then the folder is created, but no files are exported into the folder. I ran the script as i showed in the first example and it worked perfectly first time.
Copying/backing up DTS Packages
Posted - 04/27/2004 : 10:39:31
