report cause of failure in SSIS Package to event log -
06-15-2006
, 01:46 AM
Hello,
I'm running SSIS packages in the night with the Sql Server 2005 Agent.
If my SSIS package fails, e.g. because the credentials to the database
are wrong or there are duplicate keys, there will just be an unspecific
error message being reported to the event log. Is it possible to tell
the package to report detailed error information?
thanks for any help,
Urs |