Share via

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

user 126 Reputation points
2022-10-21T16:48:34.957+00:00
  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.
5,250 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,950 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,610 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,297 questions
0 comments
Accepted answer
  1. Yitzhak Khabinsky 26,201 Reputation points
    2022-10-21T16:58:18.84+00:00

    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

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 38,461 Reputation points
    2022-10-24T02:03:48.487+00:00

    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.

    253358-untitled.png

    Regards，

    Zoe Hui

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

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.