(ssis-vs2019) Improve error message if Visual Studio is running

[pascalberger]

If Visual Studio is running the ssis-vs2019 package currently exits with error code 1626. For the user it would be helpful to receive a proper error message.

[dcasota]

error code 1626 (0x65a) is documented here https://docs.microsoft.com/en-us/windows/win32/debug/system-error-codes--1300-1699-.

Before deploying sql server data tools, which product GUID aka IdentifyingNumber of installed MSI setups do you get?

get-wmiobject Win32_Product | where Name -like "*Microsoft*" | Format-Table IdentifyingNumber, Name, LocalPackage -AutoSize

Newer versions of SSDT run side-by-side with existing Visual Studio installations, but you may pass in $packageArgs the productID as well.

hope this helps.
--Daniel