March 30, 2005 at 8:09 am
Hi - I have 75 DTS pkg's on an Instance of SQL Server. I've been instructed to backup everything on this instance then DROP this instance.
I'm accustomed to saving DTS pkg's as .DTS structured storage files and backing up the SSF directory.
I recall someone mentioning that DTS pkg's are housed in MSDB.
Is there a method for backing up the DTS pkg's w/out having to open up 75 individual pkg's and saving them as SSF's?
If they are house in MSDB and I back up MSDB, how can I restore MSDB on another server w/out whacking the data in that MSDB?
thx in advance - bt
March 30, 2005 at 8:48 am
I came across this site a while back and it helps me to script out my stored procedures in one go. This link is to the dts package script. I think it only scripts one at a time, but if you put a list into an array, you should be able to run the sholw thing in one go.
http://www.nigelrivett.net/DTS/ScriptDTSProperties.html
Hope it helps
March 30, 2005 at 12:32 pm
Bill,
Here's an article by Steve Jones describing how he recovered packages from a backup of msdb. It's a bit of a hack because you're inserting into a system table, but what the hey? I recall using this method successfully a couple of years ago.
Greg
Greg
March 30, 2005 at 12:32 pm
March 30, 2005 at 12:48 pm
I use a utility from http://www.sqldts.com/ to backup DTS packages from several servers called DTSBackup2000.
You could use this utility to backup to a drive from the server and then transfer from the drive back to the server - works like a charm!!
Good Luck,
Darrell
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply