PowerShell install of SQL Server Data Tools fails, works manually

I’m installing SQL Data Tools via a PowerShell script. I run my script, but the final part where the Data Tools are installed fails (inside of the SQL installer window). If I run the script without that part, and install Data Tools manually it works.

The error is:

VS Shell installation has failed with exit code -2147205120.

The parts before this install .NET, SQL Server Management Studio, and SQL SP1. I don’t think they’re relevant to my issue, but I will post that part if requested. Here are the relevant parts. This should install Data Tools and SNAC_SDK.

try { Write-Host "Lauching SQL Server Data Tools install ..." & "\\mynetworkpath\SSDTBI_x86_ENU.exe" "/ACTION=INSTALL" "/FEATURES=SSDTBI,SNAC_SDK" "/Q" "/IACCEPTSQLSERVERLICENSETERMS" Write-Host "Installer launched ..." } catch { Write-Host "SQL Server Data Tools installation failed" exit }

As it is now, it finishes the install with that error I posted, and has installed Visual Studio, but no Data Tools.

If I run the installer manually (and check the two boxes for SSDT and SNAC_SDK) everything installs correctly.

So the PowerShell installer is working… half way…

That’s a “poorly built installer” problem. It’s probably not something you can fix.

Really? What makes you say that?

may be your error code means something similar to ‘Block’ ?