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 Integration Services
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

Answer accepted by question author
Yitzhak Khabinsky 27,196 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

Was this answer helpful?

2 people found this answer helpful.

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,551 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.

    Was this answer helpful?

    9 people found this answer helpful.
  2. 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.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Tom Phillips 17,786 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.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Tom Phillips 17,786 Reputation points
    2022-09-14T15:14:31.2+00:00

    Was this answer helpful?

    1 person found this answer helpful.

Your answer

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