Share via

SSIS Toolbox Missing

William Hull 21 Reputation points
2022-09-14T15:05:55.91+00:00

I do not have the SSIS toolbox option on my SSMS program.

I followed these direcetions:

https://learn.microsoft.com/en-us/sql/integration-services/ssis-toolbox?view=sql-server-ver16

and I still don't see the tool box.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,741 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,571 questions
Accepted answer
  1. Yitzhak Khabinsky 25,856 Reputation points
    2022-09-14T17:37:53.047+00:00

    Hi @William Hull ,

    You currently have VS2022 installed.
    Unfortunately, SSIS development tooling is not yet ready for it.
    Microsoft is still working on it.

    You would need to use the following:

    • VS2019 latest build.
    • SQL Server Integration Services Projects extension for VS2019. Version 3.16

    SQL Server Integration Services Projects Download

    1 person found this answer helpful.

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 36,281 Reputation points
    2022-09-15T02:14:13.847+00:00

    Hi @William Hull ，

    As you comment that you have downloaded Visual Studio 2019 and SSIS project.

    Just create a new SSIS project, you may see the SSIS tool box on the left.

    If the SSIS tool box still miss, to get the SSIS toolbox back, right-click on the SSIS design surface in the project and select SSIS Toolbox.

    241254-image.png

    Regards，

    Zoe Hui

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

    4 people found this answer helpful.
  2. Tom Phillips 17,731 Reputation points
    2022-09-14T15:14:31.2+00:00
    1 person found this answer helpful.
  3. Tom Phillips 17,731 Reputation points
    2022-09-14T17:31:10.803+00:00

    Oh, you are running VS 2022. There is not any SSIS support in SSDT for VS 2022. You must use VS 2019.

    https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver16

    The extension for Integration Services projects is not available for Visual Studio 2022 at this time.

    1 person found this answer helpful.
    0 comments
  4. Michael Zhang 5 Reputation points
    2023-05-08T05:25:27.76+00:00

    It's May 7 2023. I'm using VS 2022 and after you have installed SQL Server Integration Services Project 2022 extension, you can create SSIS package. If SSIS Toolbox missed, do what Zoe Hui suggested and you will find it:

    User's image

    And this is not true any more "Oh, you are running VS 2022. There is not any SSIS support in SSDT for VS 2022. You must use VS 2019.". Happy to use VS 2022! Cheers.

    1 person found this answer helpful.
    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.