VS2017 - SSIS Project

Question

Hello Team,

We are using VS2017 with SSDT installed (PFB the screenshot)

We cannot find BI projects, unable to create SSIS projects. Please advice.

Regards,

Nagesh CL

Answer 1

Hello Nagesh CL,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

I understand that you could not find BI projects, and you are unable to create SSIS projects.

Solution

If you are using Visual Studio 2017 with SQL Server Data Tools (SSDT) installed and cannot find Business Intelligence (BI) projects or create SQL Server Integration Services (SSIS) projects, putting together below are some steps you can follow to resolve the issue:

1. Even if SSDT is installed, you might still need to install the specific SSIS extension.

• Ensure that SSDT is installed correctly. You can do this by going to Tools > Extensions and Updates > Installed and checking if SSDT is listed there.
• Open Visual Studio 2017.
• Go to Tools > Extensions and Updates.
• Click on Online on the left pane.
• Search for "SQL Server Integration Services Projects".
• Click Download and install the extension.
• Restart Visual Studio after the installation is complete.

2. Make sure Visual Studio and all its components are up to date. Go to Tools > Extensions and Updates > Updates to see if there are any updates available for SSDT or other related tools.
3. If the above steps do not resolve the issue, you may need to repair your Visual Studio installation. This can fix any corrupted or missing components. To do this:
   1. Open Control Panel.
   2. Go to Programs and Features.
   3. Find Microsoft Visual Studio 2017 in the list.
   4. Click Change.
   5. Select Repair and follow the on-screen instructions.
4. Lasty, if you suspect that SSDT was not installed correctly, you can manually install it:

• Download the latest SSDT installer from the Microsoft website.
• Run the installer and follow the instructions to install SSDT with the SSIS, SSRS, and SSAS components.

After the above you should be able to resolve the issue and create SSIS projects in Visual Studio 2017 with SSDT installed.

References

Kindly use the links below for more reading and similar cases and more details steps to solve the above issue.

Source: Microsoft Documentation: Update Visual Studio. Accessed, 6/24/2024.

Source: SQL Server Integration Services Projects. Accessed, 6/24/2024.

Source: Install SQL Server Data Tools (SSDT). Accessed, 6/24/2024.

Source: Stack Overflow Discussion: Cannot Find SSIS in Visual Studio 2017 Accessed, 6/24/2024.

Source: YouTube Tutorial: How to Create SSIS Package in Visual Studio 2017. Accessed, 6/24/2024.

Source: Microsoft Documentation: Repair Visual Studio. Accessed, 6/24/2024.

Accept Answer

I hope this is helpful! Do not hesitate to let me know if you have any other questions.

** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful ** so that others in the community facing similar issues can easily find the solution.

Best Regards,

Sina Salam

Answer 2

Hi @Nagesh CL

To install Analysis Services, Integration Services, and Reporting Services project support, run the SSDT standalone installer.

The installer lists available Visual Studio instances to add SSDT tools. If Visual Studio isn't already installed, selecting Install a new SQL Server Data Tools instance installs SSDT with a minimal version of Visual Studio, but for the best experience, we recommend using SSDT with the latest version of Visual Studio.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.