SSIS - How to get the detailed error when a control flow task fails
Posted on 2010-03-30
I would like to log errors when my tasks fails in the control flow. I'm using the logging system and errors are logged fine. My problem is theses errors are not enough detailed.
I have a FTP task that move sends files. When my task fails, the error logged is "Connection manager "FTP Connection Manager" ". But when I check the Progress pane i have a more detailed error description:
Error: An error occurred in the requested FTP operation. Detailed error description: Sending file "...\Success\zmmim51_20100326_085357.cmp".
File "/.../DTS/Upload/zmmim51_20100326_085357.cmp" already exists.
This is what i want to be logged in my file.
I tried to append log in a script task, but I only have access to ErrorCode and ErrorDescription. I looked the ComponentMetaData object but it seems to be only usable in Data Flow tasks. I may be wrong.
Thanks for helping!