Can't install in VS 2019

[ASk1]

BIDS extension cannot be found in

I downloaded BI.Developer.Extensions.2.3.2.for.VS2019.vsix from
https://marketplace.visualstudio.com/items?itemName=BIDSHelper.BIDeveloperExtensionsVS2019

This extension is not installable on any currently installed products.

From log file

24.05.2019 10:55:04 - Searching for applicable products...
24.05.2019 10:55:04 - Found installed product - Global Location
24.05.2019 10:55:04 - Found installed product - ssms
24.05.2019 10:55:04 - Found installed product - Visual Studio Professional 2017
24.05.2019 10:55:04 - Found installed product - Visual Studio Professional 2019
24.05.2019 10:55:04 - Found installed product - Visual Studio Build Tools 2017 (2)
24.05.2019 10:55:05 - VSIXInstaller.NoApplicableSKUsException: This extension is not installable on any currently installed products.
at VSIXInstaller.ExtensionService.GetInstallableData(String vsixPath, String extensionPackParentName, Boolean isRepairSupported, IStateData stateData, IEnumerable1& skuData) at VSIXInstaller.ExtensionPackService.IsExtensionPack(IStateData stateData, Boolean isRepairSupported) at VSIXInstaller.ExtensionPackService.ExpandExtensionPackToInstall(IStateData stateData, Boolean isRepairSupported) at VSIXInstaller.App.Initialize(Boolean isRepairSupported) at VSIXInstaller.App.Initialize() at System.Threading.Tasks.Task1.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
at Microsoft.VisualStudio.Telemetry.WindowsErrorReporting.WatsonReport.GetClrWatsonExceptionInfo(Exception exceptionObject)

[furmangg]

Can you open Visual Studio 2019 and go to the Help... About Microsoft Visual Studio menu the. Click the Copy button and paste that info here. And also screenshot that page and upload that screenshot here.

Close the About screen and do you see any offers of Visual Studio updates? Do you maybe have a prerelease version installed?

[ASk1]

[ASk1]

All updates installed as of latest version 16.1.0
https://docs.microsoft.com/en-us/visualstudio/releases/2019/release-notes#16.1.0

And latest exSSDTBI extensions from marketplace: SSAS, SSRS, SSIS

[ASk1]

[ASk1]

Same issue with latest version 16.1.0

[furmangg]

If you open VS2019 and look in Extensions... Manage Extensions... do you see BI Developer Extensions installed already?

[furmangg]

Can you click View Install Log and save and attach the entire log as an attachment to this thread?

[ASk1]

I have installed BIDS 2.3.2 only in VS2017.
In VS2019 there is no installed BIDS and even I can't find it in Online/Visual Studio Marketplace. I downloaded it from https://marketplace.visualstudio.com/items?itemName=BIDSHelper.BIDeveloperExtensionsVS2019 as BI.Developer.Extensions.2.3.2.for.VS2019.vsix and tried to install. Please find attached log
dd_VSIXInstaller_20190528112613.log

[ASk1]

I've removed VS2019 Professional Trial and installed VS2019 Community with Data Tools and then Integration Project 3.0 Preview extension. Same error when I try to install BIDS 2019

[furmangg]

Hmm. Let me dig into the installer tonight and see if I can explain what’s wrong.

[ASk1]

Thank you, will wait
Also noticed that in BIDS 2017 expression editor in SSIS variables disappeared

[furmangg]

Try waiting 20 seconds after VS start and then clicking into Solution Explorer and then package designer and then variables window. Could be a change we made recently to make our extension load async.

[furmangg]

I was able to repro this. Apparently when VS2019 moved from version 16.0 to version 16.1 it broke the installer. We've fixed the version range it can install onto. Please search in the marketplace for BI Developer Extensions and you should find it now and be able to install version 2.3.3. Thanks so much for reporting!!

[ASk1]

Thank you, Greg. It's installed successfully. An as you recommended I wait few second and expression editor icons appeared in variables window in VS 2019. But in VS 2017 it does not appear

[furmangg]

@ASk1 can you think of anything different with your project in VS2017? (I assume you have a project and didn’t just open a .dtsx file without a project?)

Can you open VS2017... Tools... Options... BIDS Helper... Version... then screenshot it and upload that here. The codebase is nearly identical for our extension between 2017 and 2019. So my best guess is that you may be behind on SSDT updates. If that Version screen suggests you update any extensions please do.

[ASk1]

@furmangg, I appreciate your concern and I thank you for your help. Unfortunately we can't move our project to VS2019 nor upgrade SSDT in VS2017 because of new Oracle connector - we have to stay with SSDTBI 15.8.0
https://docs.microsoft.com/en-us/sql/ssdt/release-notes-ssdt?view=sql-server-2017

Please find attached screenshot and error log file.
VS2017 BIDS error log.txt

[furmangg]

Oh. Got it.

Buried in the release notes is the following recommendation for your scenario.

If you can't upgrade, then consider installing BI Developer Extensions 2.2.1 instead then disabling "automatically upgrade this extension" in Tools... Extensions and Updates.
https://github.com/BIDeveloperExtensions/bideveloperextensions/releases/tag/v2.2.1

Let me know if that works.

[furmangg]

I just reached out to the SSIS team and confirmed since 15.9.0 that Oracle is working again. There are some early adopter issues but it is supported.
https://techcommunity.microsoft.com/t5/SQL-Server-Integration-Services/Microsoft-Connector-for-Oracle-is-released-for-SQL-Server-2019/ba-p/565923

So if you prefer that approach (upgrading SSDT vs. downgrading BI Developer Extensions) feel free

[ASk1]

@furmangg Thank you very much. Switched off my network connection, installed 2.2.1 version and disabled auto update. With this version the expression editor works.

Unfortunately 15.9.0 and later oracle connector still doesn't work in dataflow with all but one our servers and I can't identify the problem. Posted comment on mentioned article.