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
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
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