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.
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.