April 10, 2008 at 10:20 am
Hi all,
I'm sure this has been asked many times before so apologies if so, but I haven't found the question (or answer) yet. If an error occurs during the execution of an SSIS package, can I find out what the error message is so that I could then email someone the details. With all the SSIS advancements on DTS I would have expected some global variable to be populated with the error message, or similar.
Many thanks.
James
April 10, 2008 at 10:47 am
The error variables are scoped to the error handler.
Click the "Event Handlers" tab, create an error handler, then look at the system variables in the variables window.
You can also enable logging to a table or file to get all of the logged details.
April 11, 2008 at 7:47 am
Thanks very much for this. Very useful.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply