Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DTS Backup
Message
From
30/10/2002 12:32:18
 
 
To
30/10/2002 11:07:31
Alvin Lourdes
Children and Youth Services Cluster
Toronto, Ontario, Canada
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Miscellaneous
Thread ID:
00716906
Message ID:
00716966
Views:
14
Alvin,

DTS Packages are stored in the msdb database. Backing this up regulary provides the most protection.

Alternate way: DTS Packages are stored in sysDTSPacages table, this data can be copied to another table with the same structure on another server (or bulk copied out). Also sysDTSPackages is how I migrate/move dts packages from one server to another. Remember sysDTSPackages is undocumented...

Bob Horkay
Previous
Reply
Map
View

Click here to load this message in the networking platform