Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

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

Avatar of TelDig
TelDigFlag for Canada asked on
Microsoft SQL Server.NET Programming
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!
Avatar of grzegorzs
grzegorzsFlag of Poland image

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

This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answers