Bandwidth Monitor
SQLDTS.comSQLIS.comSQLIS Wiki
DTSBackup 2000
By Darren Green
Version 7.0/2000
Level Beginner

DTSBackup 2000 is a designed to help with both backup and transfer of DTS packages. Whilst it is not recommended as a substitute for your normal file and database backup routines, it is an additional layer of protection, with the benefit of package level granularity. See the article Backing Up Packages for additional information.

Whilst the name is backup, it is most frequently recommend as a tool to transfer packages between servers, either directly or via a file stage.

This version of DTSBackup provides full support for Microsoft SQL Server 2000. New features introduced in this version of DTSBackup include a new DTSBackup file format and direct transfer of packages between SQL Servers. These methods do not suffer the loss of layout information encountered when using the DTS object model.

Limited support for password protected packages is also included as well as more detailed progress information and errors encountered during a transfer.

There are now two individual executables, one for manual transfer with the improved user interface, and a separate command line executable which can be installed on its own.

Full documentation is provided, so to find out more download it and give it a try.

Please mail any feature requests and bug reports here.
Remove the tinned meat decoy from the email address before sending.

Version 1.1.6 - The following bugs have been fixed:

  • Fixed issues when working with structured storage files that contain multiple versions. The most recent version is now extracted correctly.

  • (30 September 2003)

    Version 1.1.5 - The following bugs have been fixed:

  • Fixed issues when restoring a single named package file from the command line tool.

  • (03 July 2003)

    Version 1.1.4 - The following bugs have been fixed:

  • UI generated command lines were incorrect when restoring from a file, the destination parameters where omitted.
  • Restore from file sample in documentation was incorrect.

  • (23 February 2003)

    Version 1.1.3 - The following bug has been fixed:

  • A blank package description is often not blank but contains unprintable characters. The range of unprintable characters handled has now been extended.

  • (09 November 2002)

    Version 1.1.1 - The following bug has been fixed:

  • A package name that ended in a space, lost the space when saved to DTSBackup File format. This caused an error when transferring the package back into SQL Server (Local Packages)

  • (31 October 2002)

    Version 1.1.0 - The following bugs have been fixed:

  • Direct transfer of local packages may have failed as the source connection would always use trusted security.
  • The installation routine failed to detect client tools on Windows 98.

  • (24 June 2002)

    Version 1.01 - Public Release
    (7 April 2002)