Error creating a New SSIS Project with Visual Studio 2017 Community

Question

I need to create a SSIS project on VS2017 to build some ETL's. I just installed the SQL Server Data Tools from this link:

• Download and install SQL Server Data Tools (SSDT) for Visual Studio

It explains everything, but I'm still getting this message every time I try to create a project:

I did install the SSDT for VS 2017 (standalone installer).

Answer 1

SQL Server Data Tools are required to develop business intelligence projects. But you must install Integration Services and Client SDK from SQL Server Installation since it is required to build projects.

Since you are using Visual Studio community edition (free) you can install SQL Server 2017 Developer edition (free).

• https://www.microsoft.com/en-us/sql-server/sql-server-downloads

Also make sure you have checked SQL Server Integration Services in Visual Studio SSDT installer.