1

When I open a dtsx file in Visual Studio Enterprise 2017 it opens them as just an XML file. I read over this stack overflow discussion but when I do a File->New Project I don't see Integration Services Project as an option. I checked the Visual Studio Installer and I see that Data storage and processing is already installed. SQL Server Data Tools is checked too:

Installation Details

Is there something else that I need to do?

Dale K
  • 25,246
  • 15
  • 42
  • 71
Eric
  • 2,861
  • 6
  • 28
  • 59

1 Answers1

1

You may have installed SQL Server Data Tools without checking the Integration Services from the installer.

enter image description here

Also try using the standalone installer (check the link above for more details)

Hadi
  • 36,233
  • 13
  • 65
  • 124
  • Would it work then to uncheck the Data storage and processing from the Installer, let it uninstall the feature, and then reinstall the feature making sure to check the Integration Services from the installer? – Eric Apr 25 '19 at 13:26
  • I just tried that and didn't see the dialog you posted appear. – Eric Apr 25 '19 at 13:39
  • @Eric this is the standalone installer. Try it – Hadi Apr 25 '19 at 14:35
  • 1
    I did the standalone installer and Visual Studio recognized the file. I opened it and got an error (sorry I don't remember what it was). After a reboot it looks good. – Eric Apr 26 '19 at 13:37
  • Here is the link for versions prior to 2019: https://learn.microsoft.com/en-us/sql/ssdt/previous-releases-of-sql-server-data-tools-ssdt-and-ssdt-bi?view=sql-server-ver16 – DeuxAlpha Mar 28 '23 at 15:04