Search code examples
error-handlingssissql-server-2014

How to keep the number of errors and text errors in SSIS?


This is my SSIS package, and these are the requirements that have to do but i not know how:

At the level of the package is necessary to preserve the number of errors. At the level of task too, with the difference that if there is an error it is necessary to preserve the text of errors. At the level of data flow (sub-task) is necessary to preserve the text of errors.

Does anyone have an idea? SSIS package


Solution

  • Add package-level variables for storing the count of errors, and the text of errors, and populate them in the OnError event handlers of all your tasks.