VS 2019 SQL Integration and Analysis projects

chris.thomas's Avatar


20 Feb, 2020 05:42 PM

Can we get SSIS (https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects) and analysis services (https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftAnalysisServicesModelingProjects) widgets installed for VS 2019 on a standard image. These projects don't build through MSBuild, but rather to devenv cmd line.

  1. 1 Posted by chris.thomas on 20 Feb, 2020 06:23 PM

    chris.thomas's Avatar

    It looks like the analysis services projects are working, however the integration services widget needs installing.

  2. Support Staff 2 Posted by Feodor Fitsner on 20 Feb, 2020 07:19 PM

    Feodor Fitsner's Avatar

    Hi Chris,

    We can install the extension during the next update.

    For now, you can try installing it during the build with the following PowerShell script:

    $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.5/1580834301891/Microsoft.DataTools.AnalysisServices.vsix', $vsixPath)
    Write-Host "Installing package..."
    $vsPath = "${env:ProgramFiles(x86)}\Microsoft Visual Studio\2019\Community"
    Start-Process "$vsPath\Common7\IDE\VSIXInstaller.exe" "/q /a $vsixPath" -Wait

    Let me know if that worked for your project and I'll create an issue to update the image. Thank you!

  3. 3 Posted by chris.thomas on 20 Feb, 2020 10:03 PM

    chris.thomas's Avatar

    I used chocolaty to install the tool and that is working for us

  4. Support Staff 4 Posted by Feodor Fitsner on 21 Feb, 2020 12:02 AM

    Feodor Fitsner's Avatar

    Can you share the name of Chocolatey package please?

  5. 5 Posted by chris.thomas on 21 Feb, 2020 01:32 PM

    chris.thomas's Avatar


  6. Support Staff 6 Posted by Feodor Fitsner on 21 Feb, 2020 08:54 PM

    Feodor Fitsner's Avatar

    Thank you! I've created a new issue to track image update: https://github.com/appveyor/ci/issues/3323

  7. Feodor Fitsner closed this discussion on 22 Apr, 2020 09:02 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac