This project has moved and is read-only. For the latest updates, please go here.

Previous Install DTS Designer Manual Install Install SSIS Dimension Merge SCD Next

Install DTS Backup 2000

FineBuild can install and configure the DTS Backup 2000 as part of the SQL Server install process.
If you do not want to include DTS Backup 2000 in your FineBuild install, then do not download it.

DTS Backup 2000 is written by Darren Green, a SQL Server MVP specialising in DTS and SSIS. It was chosen to be included in FineBuild because it is the most effective way of exporting, importing and backing up DTS packages. In particular, it allows DTS packages to be exported and imported while retaining the DTS Designer layout and annotations.

DTS Backup 2000 home page http://www.sqldts.com/242.aspx
DTS Backup 2000 download http://www.sqldts.com/242.aspx

FineBuild DTS Backup 2000 Install

Automated silent installation of DTS Backup 2000 is performed by Process Id 4IB and is controlled by the parameters below:

Install Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014 SQL2016
SetupDTSBackup FULL Yes Yes Yes N/A N/A N/A
SetupSQLTools No No No No No No
SetupDTSBackup WORKSTATION Yes Yes Yes N/A N/A N/A
SetupSQLTools Yes Yes Yes Yes Yes Yes
SetupDTSBackup CLIENT Yes Yes Yes N/A N/A N/A
SetupSQLTools Yes Yes Yes Yes Yes Yes

In order to maintain compatibility with older versions of SQL FineBuild, the parameters InstDTSBackup and InstSQLTools can also be used.

FineBuild also uses the following parameters to help install DTS Backup 2000:
Parameter Default Value Description
DTSBackupmsi DTSBackup2000.msi Name of DTS Backup 2000 install file

DTS Backup 2000 will only be installed with CLIENT and WORKSTATION builds, but not with a FULL build.
If you want to install it with a FULL build, the following parameter should be added at run time:
/SetupSQLTools:Yes
The FineBuild install for DTS Backup 2000 includes the following:
  • Perform a DTS Backup 2000 install
  • Add a menu item for DTS Backup 2000 to the Integration Services menu.

Manual DTS Backup 2000 Install

The following steps show what you would have to do to install DTS Backup 2000 manually. FineBuild does all of this work for you automatically.

Install DTS Backup 2000

1) Navigate to the Additional Components folder and double-click on DTSBackup2000.msi.
DTS Backup Explorer msi.png
2) The Welcome window is displayed. Click Next to continue.
DTS Backup Welcome.png
3) Accept the License Agreement. Click Next to continue.
DTS Backup License.png
4) Accept the Install Location. Click Next to continue.
DTS Backup Location.png
5) Setup is ready to start installing DTS Backup 2000. Click Next to continue.
DTS Backup Ready.png
6) Install has completed successfully. Click Close to end.
DTS Backup Complete.png

Setup DTS Backup 2000 Menu Item

1) Move the menu for DTS Backup 2000 to the Microsoft SQL Server menu structure, so that all tools for SQL Server are found in one place.
Navigate to Start -> All programs. Right-click on DTS Backup 2000 and select Explore.
DTS Backup Menu Explore.png
2) Drag the DTS Backup 2000 folder to the Microsoft SQL Server 20..\Integration Services folder.
DTS Backup Menu Drag.png
Copyright FineBuild Team © 2011 - 2016. License and Acknowledgements
Previous Install DTS Designer Top Install SSIS Dimension Merge SCD Next

Last edited Nov 14, 2016 at 2:28 PM by EdVassie, version 25