SSIS Toolbox missing most tools that should be available

LorenzDA 20 Reputation points
2023-08-03T20:09:46.5266667+00:00

I am using MS Visual Studio 2022 Enterprise. I am creating SSIS packages and have SQL Server Data Tools (17.6.13.0). In the package properties I have the TargetServerVersion set to SQL Server 2017.

When I go to create SSIS packages, I view the SSIS toolbox and it is mostly empty. It only has the following tools "Data Flow Task", "Execute Package Task", "For Loop Container", "Foreach Loop Container", "Sequence Container", "CDC Control Task".

I have opened a project created in VS 2017 that has the "Execute SQL Task". When opened in VS 2022 the "Execute SQL Task" does not exist in the SSIS Toolbox and as a result it gives errors and will not run. In contrast, a colleague has VS 2022 with SQL Server Data Tools (17.6.13.0) and the TargetServerVersion set to SQL Server 2017. He does have the "Execute SQL Task" available in his SSIS data tools.

What I have tried doing: Set TargetServerVersion to SQL Server 2019 and SQL Server 2022 and then back to SQL Server 2017. This did not make a difference. I then opened Visual Studio Installer and ran all the available updates. This did not fix the problem. Lastly, I ran the repair on VS 2022 and this also did not fix the problem.

I considered removing SQL Server Data Tools with the intention of reinstalling it. However, I get a message that there are 15 other components that are dependent on it and that they would also be removed. At this point I am wondering if just uninstalling SQL Server Data Tools and reinstalling it may be the way to fix that. Before resorting to this I would like to enquire if there are any ways to get the SSIS Toolbox populated with all of the tools that should be available.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
Developer technologies | Visual Studio | Other
0 comments No comments
{count} votes

Accepted answer
  1. Yitzhak Khabinsky 26,586 Reputation points
    2023-08-03T20:39:20.4466667+00:00

    Hi @Loren Zubis,

    You would need to install SQL Server Integration Services Projects 2022 extension for VS2022: https://marketplace.visualstudio.com/items?itemName=SSIS.MicrosoftDataToolsIntegrationServices

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

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.