Creating SSIS project under VS 2017

Question

I have Visual Studio Community 2017 installed. including the Data storage and processing Workload, which includes SQL Server Data Tools.
Nonetheless, when creating a new project, I don't have the option of creating an SQL Server Integration Services (SSIS) project.
Likewise, attempting to open a project that was created under VS 2015 fails with the error "The application which this project type is based on was not found."

Before I start uninstalling and reinstalling components at random, I was hoping someone can tell me if I'm missing something trivial.

Thanks!

Answer 1

Hi @Ethan Shalev ,

Before creating SQL Server Integration Services (SSIS) project, you need to separately install the SSDT standalone installer.

In addition, for the error “The application which this project type is based on was not found”, could you tell me your project type and your Visual Studio 2015 version? In general, it is caused by missing component. Please share us more details so that we can investigate it further.

• If the answer is helpful, please click "Accept Answer" and upvote it.
  Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Sincerely,
Anna