Update SQL table from System:ErrorDescription message in SSIS

Question

Hi Everyone,

I have import excel files and I want to update my custom error log table using error description from SSIS
i try to use event handler and put it in OnError. it does update the other column but not the status_description which i set to get error messages. Below is my script, im using sqlstatementsource and SQL Statetment but both of them does not give the error messages.
Can anyone give me insight?
Thanks

Answer 1

Hi @Ivan Raditya ,

Click the parameter mapping in the left column and add each paramter from your command and map it to your SSIS variable.

Make sure that you map them correctly.

Refer to execute-sql-task about the mapping.

Regards，

Zoe

---

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.