Install DTS Backup 2000
| 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 |
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:
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.
-
Navigate to the Additional Components folder
Double-click on DTSBackup2000.msi
-
The Welcome window is displayed
Click Next to continue
-
Accept the License Agreement
Click Next to continue
-
Accept the Install Location
Click Next to continue
-
Setup is ready to start installing DTS Backup 2000
Click Next to continue
-
Install has completed successfully
Click Close to end
-
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
-
Drag the DTS Backup 2000 folder to the Microsoft SQL Server 20..\Integration Services folder.
Copyright FineBuild Team © 2011 - 2020. License and Acknowledgements
| Previous Install DTS Designer | Top | Install SSIS Dimension Merge SCD Next |
|---|