The scriptmain.cs can not be found in the SSIS package

Question

I have a SSIS package with a script task. I can edit this script taks, but when I add a breakpoint in the C# code and I run the package I get an error that the ScriptMain.cs can not be found.

I use Visual studio 2022 with data tools 2017 and integration services 2022

Can somebody help me with this?

Answer 1

Hi @Eric Bezemer , Welcome to Microsoft Q&A,

Make sure you have installed the correct versions of SQL Server Data Tools (SSDT) and Integration Services extensions. You mentioned that you're using Data Tools 2017 and Integration Services 2022, confirm that these versions are compatible with Visual Studio 2022.

Try rebuilding the script task to make sure your project is configured correctly, including the debug configuration and the target framework. Make sure that the 'ScriptMain.cs' file in the script task is correctly included in the project and that there are no issues with the path.

Best Regards,

Jiale

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Eric Bezemer,

The Data Tools 2017 are irrelevant to you.

SSIS dev. machine needs the following:

• VS2019/VS2022
• Relevant "SQL Server Integration Services Projects" extension for VS2019/VS2022. They are different for each VS version.
• Microsoft Visual Studio Tools for Applications 2019/2022
  It is installed by the Extension above.

When you editing or debugging, the Microsoft Visual Studio Tools for Applications is engaged.

I am thinking that you need to repair it in Control Panel.

If it doesn't help, you can completely uninstall, and reinstall it manually.