SSIS 2022 Script Component Runtime Error

libpekin 86 Reputation points
2024-06-25T19:05:46.56+00:00

Hello,

I've configured a Data Flow error redirection and is using a Script Component to capture the error description and column but is getting the attached runtime error.

User's image

I am running the latest version of VS2022.
User's image

Thanks

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,508 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Michael Taylor 50,836 Reputation points
    2024-06-25T19:45:32.78+00:00

    This is insufficient information to help you. Look at the execution logs to get a detailed error message. Just off my head it sort of looks like an issue getting data within a script. I'd wager the data isn't getting passed but without knowing anything but a stacktrace it is hard to say. If you are using a script task have you tried setting a breakpoint on it and confirming that you're passing all the correct data into the script?


  2. Olaf Helper 42,921 Reputation points
    2024-06-26T05:37:14.2433333+00:00

    using a Script Component to capture the error

    Debug the script task to see where & why the error occurs.

    0 comments No comments

  3. libpekin 86 Reputation points
    2024-06-26T17:19:34.2966667+00:00

    Please find attached the error details and the Input0_ProcessInputRow method:

    User's image

    User's image

    0 comments No comments