BimlExpress and VS2019 issues

Question

Anyone successfully using BimlExpress and Visual Studio 2019 ?

The latest version of BimlExpress currently available is version 5.0.64108.0 aka 2019 R1, but it is in any way incompatible with Vs2019 version 16.9+

I'm writing this in hope that someone have found a workaround, or have a version where iit still working.

Update: Trying to open a biml file freezes up Visual Studio entirely.

Answer 1

You haven't described any symptoms but I had a couple of bumps getting BIMLexpress to show up in VS2019.

First I had to go to extensions on the menu and check that it showed up. it did but right clicking on the SSIS Packages node didn't show anything. I clicked Toggle BIDS helper menus.

I restarted VS2019 and there is a yellow bar under the menu warning about extensions using deprecated API's. I enabled deprecated API usage and restarted then BIMLexpress displayed more entries in the extensions menu. Still no right click. Haven't road tested it yet other than adding a new BIML file.

The yellow bar may have been there all along and I just didn't notice it so the toggle BIDS helper step might be unnecessary.

Answer 2

The extension BimlExpress only works with SQL Server Integration Services Projects 3.x. Newer Versions are not compatible. Did you check this? If necessary downgrade.

Answer 3

"Downgrade" Version of Integration Services can be downloded directly from marketplace

Use Version 3.16 (latest GA Version).

worked for me :-)