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 |
|
nicole
Yak Posting Veteran
97 Posts |
 Posted - 2006-01-24 : 23:34:50
|
| How can I export DTS package? There's an option to save DTS as Structured Storage File in the Import/Export Wizard, but a table must be specified which is not I want.... |
|
|
mcarahul
Starting Member
11 Posts |
Posted - 2006-01-25 : 02:24:45
|
| Open a DTS packageClick Package then Save AsIn loacation u can specify as Structured Storage File.Rahul Sharma |
 |
|
|
nicole
Yak Posting Veteran
97 Posts |
Posted - 2006-01-26 : 00:08:01
|
oh~ that means I have to do it one by one  but.... silly question  what structured storage file for? can it be a way to backup the dts? |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-01-26 : 03:10:30
|
| i haven't really tried this but you can import the dts packages from sysdtspackages--------------------keeping it simple... |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-26 : 09:18:24
|
| I think when u backup master table, the DTS also gets backed up. But check that. |
|
|
|
nicole
Yak Posting Veteran
97 Posts |
Posted - 2006-01-27 : 03:21:22
|
| I learnt from this forum that backing up the msdb does back up the dts. But I wonder, in case I only need to restore one of the dts, can I do that? |
|
|
|
nicole
Yak Posting Veteran
97 Posts |
Posted - 2006-01-27 : 03:24:06
|
| Is sysdtspackage a table? Where to locate it? |
|
|
|
|
|
|
Export DTS