Backup of my DTS Package

  • How do I take Backup of my DTS Package

  • Depends on what you really want to do as far as restoreability of them. Two methods are: 1. Backup msdb regularly, this allows restore of DTS plus other objects stored in msdb such as maint plans etc. or 2. In dts designer choose save as and either save the dts packages to another sql server environment or as a structured storage file external from sql server. Of course this wouldn't be very practical for environments with hundreds of dts packages or on a regular basis.

  • If you look for UI, have a look at http://www.sqldts.com/?242

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply