Clever Geek Handbook

Getting error and error messages in SSIS

I want to create a generic error handling package that should be called from my other packages when something goes wrong. In this error handling package, I want to log which task failed and the reason for the failure. How can I get this information?

I am using a thread priority constraint to specify the Execute Package task that executes the error handling package when something goes wrong.

+2


source to share


2 answers


I did this, the only thing I needed was the executable and the logging to the sql server so that I could execute a query like this:



SELECT event, computer, statement, source, start time, end time, message FROM sysdtslog90 WHERE (executeid = '?') AND (event = N'OnError ') ORDER BY starttime DESC

+1


source


Take a look at the following article by Jamie Thomson, which shows how to get an error description using a Script task.

http://consultingblogs.emc.com/jamiethomson/archive/2005/08/08/1969.aspx



You can find an alternative approach to error handling in SSIS in this article from SQL Server Central

Error Handling in SSIS

0


source






More articles:


All Articles