SSIS 2022 Script Component Runtime Error

libpekin 86 Reputation points


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


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

    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

    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

    Please find attached the error details and the Input0_ProcessInputRow method:

    User's image

    User's image

    0 comments No comments