I have a EXECUTE SQL Task that is calling a stored proc from SQL.. I have onerror event setup on this task to write into a log table if an error occurs on this particular task.- I use the @[System::ErrorDescription] to capture the error.The issue is that when task failed it wrote into the log table, but it ONLY Wrote this particular err messageExecuting the query "Sp_test?, ?,?,?,?,?,? output" failed with the following error: "The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. - IT DID NOT Put the error messsage "Error: String or binary data would be truncated."When I look at the execution results, it shows both the errs messages listed below, but in my table it only logged this errExecuting the query "Sp_test?, ?,?,?,?,?,? output" failed with the following error: "The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Can you pl advise why it didnot write this Error: String or binary data would be truncated.into the log tbl?---------Error: String or binary data would be truncated.[Execute SQL Task] Error: Executing the query "Sp_test?, ?,?,?,?,?,? output" failed with the following error: "The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

SSIS captures just that error message.If you want to capture the other one to u need to use the on information event.In this case all the messages will be logged.You need to remove all the message u dont want.Hope this helps !! Please close the threads once answered - Sudeep

But that is Also an error correct, so shud it Not be captured to?This is what I have in my onerr event:"Insert into DBLog ( fielda, fieldb, fieldc, fieldd) values ( 'At' , '"+ (DT_STR,80,1252) @[System::ContainerStartTime] +"', 'procedure','Task Name : ' + ' "+(DT_STR,1000,1252) @[System::SourceName] +"' + char(32) + '.' + '" + (DT_WSTR,50)@[System::ErrorCode] +" : ' +'"+ (DT_STR,1000,1252)Replace(@[System::ErrorDescription],"'","''") +"'+ 'On ID: " + (DT_STR,30,1252)@[User::id]+ " + Cn: " + (DT_STR,30,1252)@[User::CY]+ " ' ) " + " \r\n" + "go" + "\r\n" +

As per my understanding the onError event gets triggered just once and records the 1st or the last error description. Thats how it is cant really help.Hope this helps !! Please close the threads once answered - Sudeep

What do u propose then? How can I get both the errors or even jus tthe first one, since that is mostly the one that has meaningful err

Check my earlier post.Hope this helps !! Please close the threads once answered - Sudeep

hi Desigal,my approach wont work.Not sure how can we capture the other logs.Will let you know if I get a way out.Hope this helps !! Please close the threads once answered - Sudeep

Please see this post from Jamie:http://blogs.conchango.com/jamiethomson/archive/2005/08/08/SSIS-Nugget_3A00_-Get-error-descriptions.aspx

We were getting the same error as below. Error: String or binary data would be truncated. [Execute SQL Task] Error: Executing the query "INSERT INTO XXX VALUES ..." failed with the following error: "The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. We were only adding 2 columns and almost those values was inside the limit of the variables. At the end of the day we found out that this error was related with the other variables which has been added by default. Default value was exceeding the limit of varialbe limit. I would suggest to check all fields and also their default values if they are still insdie the variable limit.