Error when installing SSDT (SQL Server Data Tools)

sql visual-studio-2017 ssms sql-server-data-tools sql-server-2017
Edwin picture Edwin · Dec 19, 2017 · Viewed 39.5k times · Source

I have a problem during the installation of SQL Server Data Tools for Visual Studio 2017

I get the following error (translated): 

The requested meta file operation is not supported (0x800707D3)

Screenshot: See here

Log file available here: https://www.dropbox.com/s/e34kry9ycj76j7n/SSDT-Setup-ENU_20171219090643.log?dl=0

Here's the relevant section from the linked log file:

[13C4:3020][2017-12-19T10:07:22]i000: MainViewModel.OnPackageActionProgress: Percent completed: 0, Overall progress: 27
[13C4:3020][2017-12-19T10:07:22]i000: MainViewModel.OnPackageActionProgress: Percent completed: 0, Overall progress: 27
[13C4:3020][2017-12-19T10:07:22]i000: MainViewModel.OnPackageActionProgress: Percent completed: 0, Overall progress: 27
[13C4:3020][2017-12-19T10:07:22]i000: MainViewModel.OnPackageActionProgress: Percent completed: 0, Overall progress: 27
[13C4:3020][2017-12-19T10:08:49]i000: MainViewModel.OnPackageActionProgress: Percent completed: 0, Overall progress: 27
[13C4:3020][2017-12-19T10:08:51]i000: MainViewModel.OnPackageActionProgress: Percent completed: 0, Overall progress: 27
[13C4:3020][2017-12-19T10:08:51]i000: MainViewModel.OnPackageActionProgress: Percent completed: 0, Overall progress: 27
[13C4:3020][2017-12-19T10:08:51]i000: MainViewModel.OnPackageAction: Install Completed for package SQL Server Integration Services 2012 (id: SSISOneDesigner2012)
[13C4:3020][2017-12-19T10:08:51]i319: Applied rollback package: SSISOneDesigner2012, result: 0x0, restart: None
[4214:2830][2017-12-19T10:08:51]i329: Removed package dependency provider: {DB97C76B-9116-42C5-8814-0041856EB9E6}, package: SSISOneDesigner2012
[4214:2830][2017-12-19T10:08:51]i329: Removed package dependency provider: Microsoft.DataTools.ReportingServices, package: Microsoft.DataTools.ReportingServices
[4214:2830][2017-12-19T10:08:51]i329: Removed package dependency provider: Microsoft.DataTools.AnalysisServices, package: Microsoft.DataTools.AnalysisServices
[13C4:3020][2017-12-19T10:08:51]i000: MainViewModel.OnPackageActionProgress: Percent completed: 100, Overall progress: 100
[4214:2830][2017-12-19T10:08:51]i372: Session end, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{058aacb1-dd61-42d2-951e-fc2d0b51c456}, resume: None, restart: None, disable resume: No
[4214:2830][2017-12-19T10:08:51]i330: Removed bundle dependency provider: {058aacb1-dd61-42d2-951e-fc2d0b51c456}
[4214:2830][2017-12-19T10:08:51]i352: Removing cached bundle: {058aacb1-dd61-42d2-951e-fc2d0b51c456}, from path: C:\ProgramData\Package Cache\{058aacb1-dd61-42d2-951e-fc2d0b51c456}\
[4214:2830][2017-12-19T10:08:51]i371: Updating session, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{058aacb1-dd61-42d2-951e-fc2d0b51c456}, resume: None, restart initiated: No, disable resume: No
[13C4:3020][2017-12-19T10:08:51]e000: MainViewModel.OnBundleAction: Bundle action failed: De aangevraagde metabestandsbewerking wordt niet ondersteund (0x800707D3)
[13C4:3020][2017-12-19T10:08:51]i399: Apply complete, result: 0x800707d3, restart: None, ba requested restart:  No
[13C4:2DC4][2017-12-19T10:09:07]i000: MainViewModel.OpenUrl: Opening url: C:\Users\GEBRUI~1\AppData\Local\Temp\SsdtSetup\SSDT-Setup-ENU_20171219090643.log
[13C4:2DC4][2017-12-19T10:10:35]i000: MainViewModel.OpenUrl: Opening url: 
C:\Users\GEBRUI~1\AppData\Local\Temp\SsdtSetup\SSDT-Setup-ENU_20171219090643.log

I have installed SQL Server Management Studio 17, and then SQL Server 2017 shortly before.

-

Can anyone help with this?

Answer

mhenry1384 picture mhenry1384 · May 9, 2019

I got this attempting to install SSDT to Visual Studio 2019 (the only version of VS I have installed). Fixed by telling SSDT to install the standalone Visual Studio 2017 option, and installed the extension "SQL Server Integration Services Projects" in Visual Studio 2019.

Related questions

How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More