Commands for installing SQL Server Integration Services Projects without prompts, removing it again and detecting it from deployment tools. A command is shown only when it is certain: from the manifest or the installer technology’s documented default.
Related guide: Silent install switches: MSI, NSIS, Inno Setup · Uninstall a program with the registry or PowerShell
With winget
PowerShell
winget install --id Microsoft.DataTools.IntegrationServices -e --silent --accept-package-agreements --accept-source-agreementswinget upgrade --id Microsoft.DataTools.IntegrationServices -e --silentwinget uninstall --id Microsoft.DataTools.IntegrationServices -e --silentBy installer
32-bit · EXE (WiX Burn) · All users
Silent install
Microsoft.DataTools.IntegrationServices.exe /quiet /norestartUninstall
msiexec /x {36408E1E-DEB6-47D8-BFF0-37776BEBAC61} /qn /norestart- MSI product code
- {36408e1e-deb6-47d8-bff0-37776bebac61}
- Uninstall registry key
- HKLM\SOFTWARE\WOW6432Node\Microsoft\Windows\CurrentVersion\Uninstall\{36408e1e-deb6-47d8-bff0-37776bebac61}
- UpgradeCode
- {9973B73D-2566-47B7-933F-2198D4E285BF}
PowerShell: download, verify, install
Downloads the official file, checks its SHA256 and installs it silently.
install-sql-server-integration-services-projects.ps1
$url = 'https://ssis.gallerycdn.vsassets.io/extensions/ssis/microsoftdatatoolsintegrationservices/2.1.2/1764774570388/Microsoft.DataTools.IntegrationServices.exe'
$sha256 = '75D8444333303D5B449660A669AF07862289E5F2BBDEF0AE7520C5BA3E47D65B'
$file = Join-Path $env:TEMP 'Microsoft.DataTools.IntegrationServices.exe'
Invoke-WebRequest -Uri $url -OutFile $file -UseBasicParsing
if ((Get-FileHash $file -Algorithm SHA256).Hash -ne $sha256) { throw 'SHA256 mismatch' }
Start-Process -FilePath $file -ArgumentList '/quiet /norestart' -Wait