scripts/Windows/install_ssis_vs2019.ps1
|
Write-Host "Installing SQL Server Integration Services Projects" -ForegroundColor Cyan # install runtime Write-Host "Downloading..." $exePath = "$env:TEMP\Microsoft.DataTools.IntegrationServices.exe" (New-Object Net.WebClient).DownloadFile('https://ssis.gallerycdn.vsassets.io/extensions/ssis/sqlserverintegrationservicesprojects/3.9/1598239170220/Microsoft.DataTools.IntegrationServices.exe', $exePath) Write-Host "Installing..." cmd /c start /wait $exePath /quiet Remove-Item $exePath Write-Host "SQL Server Integration Services Projects installed" -ForegroundColor Green # ----- Write-Host "Installing Microsoft Analysis Services Projects" -ForegroundColor Cyan $vsixPath = "$env:TEMP\data-tools.vsix" Write-Host "Downloading VS extension package..." (New-Object Net.WebClient).DownloadFile('https://probitools.gallerycdn.vsassets.io/extensions/probitools/microsoftanalysisservicesmodelingprojects/2.9.13/1599609948622/Microsoft.DataTools.AnalysisServices.vsix', $vsixPath) Write-Host "Installing package..." $vsPath = "${env:ProgramFiles(x86)}\Microsoft Visual Studio\2019\Community" if (-not (Test-Path $vsPath)) { $vsPath = "${env:ProgramFiles(x86)}\Microsoft Visual Studio\2019\Preview" } Start-Process "$vsPath\Common7\IDE\VSIXInstaller.exe" "/q /a $vsixPath" -Wait Write-Host "Microsoft Analysis Services Projects installed" -ForegroundColor Green |