Jump to Install SSDT with Visual Studio 2017 - To install SSDT during Visual Studio installation, select the Data storage and processing workload,.
Active1 year, 1 month ago
I do not see an option to create an SSIS project using Visual Studio 2017.
Hadi29k88 gold badges3535 silver badges8080 bronze badges
SKhSKh16211 gold badge22 silver badges1111 bronze badges
6 Answers
VS2017 supports ssis or ssrs projects if you install SSDT for VS2017 here.
Click on the newly downloaded file and check SSIS or SSRS components that you required, as show in diagram :-
Once you have installed this, try opening ssis / ssrs project. I managed to open ssis developed on vs2010.
You should see these component installed. (reboot if you don't see them).
Try open your project again. If you get 'incompatible project' - right click on your project, select 'reload project' (not reopen the solution)
kepungkepung1,14111 gold badge1414 silver badges1919 bronze badges
Information on this will probably get outdated fast because Microsoft is running to complete its work on this, but as today, June 9th 2017, support to create SQL Server Integration Services (SSIS) projects on Visual Studio 2017 is not available. So, you can't see this option because so far it doesn't exist yet.
Beyond that, even installing what is being called SSDT (SQL Server Data Tools) in VS 2017 installer (what seems very confusing from Microsoft's part, using a known name for a different thing, breaking the behavior we expect as users), you won't see SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) project templates as well.
Actually, the Business Intelligence group under the Installed templates on the New Project dialog won't be present at all.
You need to go to this page (https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt) and install two separate installers, one for SSAS and one for SSRS.
Once you install at least one of these components, the Business Intelligence group will be created and the correspondent template(s) will be available. But as today, there is no installer for SSIS, so if you need to work with SSIS projects, you need to keep using SSDT 2015, for now.
rene34.9k1212 gold badges8585 silver badges117117 bronze badges
Aureliano BuendiaAureliano Buendia
I havent tried this scenario yet - I was scared off by the (unanswered) comments below the GA announcement blog post:
I'll be staying on VS15 for a while ...
Mike HoneyMike Honey12k11 gold badge1414 silver badges3232 bronze badges
Integration Services project templates are now available in the latest release of SSDT for Visual Studio 2017.
Note: if you have recently installed SSDT for Visual Studio 2017. You need to remove the Reporting Services and Analysis Services installations before you proceed with installing SSDT.
AdeAde
There is no BI project in Visual Studio. Youll need to download SSDT. SSDT 2017 works fine :)
SqlKindaGuySqlKindaGuy2,84622 gold badges88 silver badges2121 bronze badges
SSIS Integration with Visual Studio 2017 available from Aug 2017.
I installed in Jul 2018 and appears working fine. See Download link
rchackorchacko
protected by Community♦Sep 22 '17 at 18:33
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
Would you like to answer one of these unanswered questions instead?