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

Eric Bezemer 186 Reputation points
2024-07-17T08:24:57.6333333+00:00

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?

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,862 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,517 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,615 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Jiale Xue - MSFT 42,411 Reputation points Microsoft Vendor
    2024-07-17T09:37:33.9166667+00:00

    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.

    0 comments No comments