why can't I create an SSIS project from visual studio 2019?

user 106 Reputation points
  1. I installed visual studio 2019 correctly with the SSDT option
  2. I installed sql server 2019 correctly with options integration services, analysis services and reporting services
  3. when I use visual studio to create an ssIS project, nothing is displayed (file > new project); I can't see business intelligence solutions in visual studio 2019 when I try to create a new project

Please what is the problem?

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,122 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,641 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,328 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,209 questions
0 comments No comments
{count} votes

Accepted answer
  1. Yitzhak Khabinsky 24,016 Reputation points

    Hi @user ,

    There no more SSDT for VS2019 SSIS projects.

    You need to download, and install SQL Server Integration Services Projects extension for VS2019 SSIS projects.

    Here is its download link: SQL Server Integration Services Projects
    IMPORTANT: Please download v.3.16, and ignore any 4.* versions.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. ZoeHui-MSFT 27,466 Reputation points

    Hi @user ,

    Create a blank solution
    Extensions ... Manage Extensions
    Online ... Visual Studio Marketplace
    SQL Server Integration Services Projects
    Download and install

    Please note that VS2019 removed the business intelligence catalog, you may need to search for integration to create SSIS project.



    Zoe Hui

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

    0 comments No comments