Visual Studio 2017 has no Business Intelligence to create SSIS package

Question

I installed Visual Studio 2017 and using this link https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt

I installed SSDT for visual studio 2017 also I installed Data-Tier Application Framework (DacFx) 17.4 (64bit and 32 bit) which is used by VS2017.as shown in first pic its show SQL Server Data Tools is installed on VS2017

but when I try to create new SSIS project I dont see Business Intelligence as shown in the pic2

Your help is appreciated

You are showing C# templates, have you checked SqlServer option? — McNets, Apr 05 '18 at 20:47
yeah, SQL server has only SWL Server Database Project @McNets — , Apr 05 '18 at 20:49
if u mean shutting down VS and again starting, yes I did, even I rebooted my OS :D @dfundako — , Apr 05 '18 at 20:50
I tried this before, what i explained I have done so far was based on this but still not showing @McNets — , Apr 05 '18 at 20:56

score 2 · Answer 1 · answered Apr 05 '18 at 22:50

ok here is the solution, what i did is i uninstall SSDT, again tried to instal SSDt but this time I selected "Visual Studio Professional 2017" and only "Sql Server Integration Service" as shown in pic1

and now I have Business Intelligence template when I want to create new project as shown in pic2

score 0 · Answer 2 · answered Oct 17 '22 at 20:58

0

I had the same issue, So install the SSIS first and then SSRS and then SSAS will install everything and solve the issue.

answered Oct 17 '22 at 20:58

Surya prakash Pareek

1

Visual Studio 2017 has no Business Intelligence to create SSIS package

2 Answers2