General information
Forum:
Microsoft SQL Server
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only