Visual Studio 2017 has no Business Intelligence to create SSIS package

1
votes

I installed Visual Studio 2017 and using this link https://docs.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 enter image description here

but when I try to create new SSIS project I dont see Business Intelligence as shown in the pic2enter image description here

Your help is appreciated

1
sqlvisual-studiossis
You are showing C# templates, have you checked SqlServer option? – McNets
yeah, SQL server has only SWL Server Database Project @McNets – user9245800
Have you tried turning it off and back on again? – dfundako
if u mean shutting down VS and again starting, yes I did, even I rebooted my OS :D @dfundako – user9245800
Look this: stackoverflow.com/a/46700769/3270427 – McNets

1 Answers

2
votes

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 enter image description here

and now I have Business Intelligence template when I want to create new project as shown in pic2enter image description here