Biml extension doesn't show up in Visual Studio 2019

Question

I'm getting my head around how to install Biml extention in VS 2019. I followed the instruction from https://devblogs.microsoft.com/visualstudio/updates-to-synchronous-autoload-of-extensions-in-visual-studio-2019/ to a T, I mean I clicked "Allow synchronous autoload of extentions", then installed the extention but I still can't create a biml file. In VS 2017 it works fine but in the higher version it seems really tricky to get it to work.

Answer 1

SQL Server Data tools does not support BIML solution anymore (deprecated).

Download version 3.16

https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects

Remove SSDT from current install (Visual Studio Installer)

Run the install file downloaded from marketplace:

That should do it.