troubleshooting Question

SSIS - How to get the detailed error when a control flow task fails

Avatar of TelDig
TelDigFlag for Canada asked on
.NET ProgrammingMicrosoft SQL Server
4 Comments1 Solution1004 ViewsLast Modified:

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!

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros