Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
william_lee78
Yak Posting Veteran
53 Posts |
 Posted - 2004-10-06 : 06:22:25
|
| Hi All,Does anyone know how to backup a DTS package? Can I use the SQL Backup to backup my DTS package created under Local Packages? If someone know, pls teach me how to do it. Thank you |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-06 : 06:51:15
|
if you backup the msdb database, then you already made a backup of the package. |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-10-06 : 23:47:07
|
| You can also open up the package and do a Save As. It lets you save it as a structured file to a directory somewhere. This gives you a little more granular control than backing up msdb.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
william_lee78
Yak Posting Veteran
53 Posts |
Posted - 2004-10-07 : 02:08:33
|
| Hi Jen and Derrickleggett,Thank you for the solution. Basically, I'm using Save As method at the moment. But, will try out Jen solution soon.Thank you so much for the help. |
|
|
|
|
|
|
Backup DTS Package