SSIS 2022 Script Component Runtime Error

Question

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.

I am running the latest version of VS2022.

Thanks

Answer 1

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?

Answer 2

using a Script Component to capture the error

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

Answer 3

Please find attached the error details and the Input0_ProcessInputRow method: