SSIS - The task with the name "Execute SQL TASK" not registered for use on this computer

Question

Hello, I have problem with SSIS Execute SQL Task. I get this error message when i try to open Execute SQL Task . Can someone help me? I am using Visual Studio 2022 and SQL Server 2022. Thank you, Martin

Answer 1

Hi @Vyvadil Martin,

VS2022 is not ready for prime time. Its SQL Server Integration Services Projects extension v.0.3 is just a preview with multiple bugs and limitations.

In the meantime, it is better to stay with the VS2019 and its SQL Server Integration Services Projects extension v.4.4. It does support SQL Server 2022.

Answer 2

Hi @Vyvadil Martin,

SSIS2022 is not the GA version now, it is still under test.

Please try to use VS2019 to design your package which could also deploy packages to SQL Server 2022.

Regards，

Zoe Hui

---

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

Answer 3

I was able to do what I need with the "Execute SQL Task" using the "Execute T-SQL Statement Task".