All geek questions in one place

Which SSIS system variable contains the error text

I am running an SSIS package using SQL Server 2008 Job. The packet failed at some point during operation. I created my own mechanism to capture the error and write it to the table. Therefore, I see that there is an error with a specific task, but could not find what the error is.

When I run the same package from BIDS, it works fine. no error.

What I want to do, I need to write this error line to my own table, which is shown on the tab "Result of execution".

So the question is which system variable contains the error string in SSIS.

+4
source share
2 answers

The error is stored in the ErrorDescription system variable . See Error Handling in a Data Stream for an example of how to get a description of the error.

In addition, if you want to write error information to a table, SSIS supports writing to a table using SQL Server Log Provider . You can also configure logging.

+11
source

Check this one out ! He explained step by step how to configure SSIS logging with the error message parameter.

0
source

Source: https://habr.com/ru/post/1394933/

More articles:


All Articles