Q:

How can I upgrade SSIS project dtproj files from 2008 to 2017

After installing SSDT for SQL Server 2017 in VS 2017, I still cannot load an earlier version's dtproj file.

This project is incompatibility with the current edition of Visual Studio

The old .dtproj looks like this:
<Project xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <ProductVersion>10.50.1600.1</ProductVersion>
  <SchemaVersion>9.0.1.0</SchemaVersion>

The newer dtproj looks like this:
<Project xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <DeploymentModel>Project</DeploymentModel>
  <ProductVersion>14.0.800.60</ProductVersion>
  <SchemaVersion>9.0.1.0</SchemaVersion>

In general they appear similar. I haven't really seen any documentation at https://docs.microsoft.com/en-us/sql/ssdt/changelog-for-sql-server-data-tools-ssdt that addresses how to upgrade the project files.
Is there any tooling for performing upgrades?

A:

SSDT 15.8.1 has an import .ispac wizard that will create the components for you.  Setup is a bit tricky though.
Steps to Setup

Install "Microsoft Analysis Services Projects" VS extension in VS2017.
Download SSDT 15.8.1 here: https://go.microsoft.com/fwlink/?linkid=2024393
During install, select a "New instance" (DO NOT use existing VS2017 instance because it will fail with a vague "Recursion too deep; stack overflow" error).  New instance will be named SSDT by default.
Open SSDT VS instance and go File > New Project > Business Intelligence > Integration Services.
Select Integration Services Import Project Wizard and browse to ispac that you want to use.

All components should be created for you.

