c# - Only Get First Part Of Error Description Message in SSIS Package -

c# - Only Get First Part Of Error Description Message in SSIS Package -

i have ssis bundle writes info table when fails. of info scheme variable errordescription. question how first part of errordescription , not whole message long , doesn't contain useful info , have generate study on errors , error message long report.

thanking in advance.

if me, want entire message table every time, , limit characters select study if it's long. if don't store entire error message, might regret 1 time chop off useful information.

however, can limit characters store using left() function in sql command store error info in table.

c# sql ssis