Introduction
There is no information about which file is installed by which setup.
This tip lists the files that are installed on a Windows 7 Virtual PC by the Windows 7 setup and by the Microsoft SQL Server 2008R2 setup.
Background
I was trying to find out what has to be installed so that SSIS packages may be run. SSIS packages can be run from the command-line with the utility dtexec.exe. However, I prefer to run them through the tool dtexecUI.exe which provides a user interface. But what has to be installed, so that dtexecUI is installed?
I installed a Virtual PC with Windows 7 and began to install components of the SQL server 2008R2, and looked at what files were installed. I found out that dtexec and dtexecUI are installed by the "Management Tools - Basic" component. However, when I opened an SSIS package (.dtsx file) with dtexecUI, an error appeared saying that the Integration Services must also be installed.
After each setup, I saved the list of all files on the disk with the following command:
dir /b /s >Windows7Files.txt
These files are in the above download link. The files contain the following:
- Windows7Files01.txt: Windows 7 on a Virtual PC
- Windows7Files02WithIntegrationComponents.txt: with Integration Components for Virtual PC
- Windows7Files03WithSqlServerSetupSupport.txt: with SQL server 2008R2 Setup Support
- Windows7Files04WithSqlIntegrationServices.txt: with SQL server 2008R2 Integration Services
- Windows7Files05ManagementToolsBasic.txt: with SQL server 2008R2 Management Tools - Basic
With a compare tool, for example WinDiff, you may see which files are installed by Windows 7, Integration Components, SQL Server 2008R2 Setup Support, Integration Services and Management Tools Basic by comparing the corresponding file, with the previous file in this list.
History
- 11th November, 2014: Initial version
