Install DTS Backup 2000 - SQL-FineBuild/Common GitHub Wiki

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

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 former 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.

Page Location
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:

SQL Version Parameter FULL Build WORKSTATION Build CLIENT Build
SQL2019 /SetupDTSBackup: N/A N/A N/A
/SetupSQLTools: No Yes Yes
SQL2017 /SetupDTSBackup: N/A N/A N/A
/SetupSQLTools: No Yes Yes
SQL2016 /SetupDTSBackup: N/A N/A N/A
/SetupSQLTools: No Yes Yes
SQL2014 /SetupDTSBackup: N/A N/A N/A
/SetupSQLTools: No Yes Yes
SQL2012 /SetupDTSBackup: N/A N/A N/A
/SetupSQLTools: No Yes Yes
SQL2008R2 /SetupDTSBackup: Yes Yes Yes
/SetupSQLTools: No Yes Yes
SQL2008 /SetupDTSBackup: Yes Yes Yes
/SetupSQLTools: No Yes Yes
SQL2005 /SetupDTSBackup: Yes Yes Yes
/SetupSQLTools: No 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 is only included with CLIENT and WORKSTATION builds, but not with a FULL build. It cannot be installed with SQL2012 or above.

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:

Top

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

    Double-click on DTSBackup2000.msi

    ![Explorer](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/IntegrationServicesExtras/DTSBackup/DTS Backup Explorer msi.png)

  2. The Welcome window is displayed

    Click Next to continue

    ![Welcome](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/IntegrationServicesExtras/DTSBackup/DTS Backup Welcome.png)

  3. Accept the License Agreement

    Click Next to continue

    ![License](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/IntegrationServicesExtras/DTSBackup/DTS Backup License.png)

  4. Accept the Install Location

    Click Next to continue

    ![Install Location](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/IntegrationServicesExtras/DTSBackup/DTS Backup Location.png)

  5. Setup is ready to start installing DTS Backup 2000

    Click Next to continue

    ![Ready to Install](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/IntegrationServicesExtras/DTSBackup/DTS Backup Ready.png)

  6. Install has completed successfully

    Click Close to end

    ![Complete](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/IntegrationServicesExtras/DTSBackup/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](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/IntegrationServicesExtras/DTSBackup/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](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/IntegrationServicesExtras/DTSBackup/DTS Backup Menu Drag.png)

Copyright FineBuild Team © 2011 - 2020. License and Acknowledgements

Previous Install DTS Designer Top Install SSIS Dimension Merge SCD Next