September 21, 2012 at 2:11 pm
Hi,
I need to apply error handling in SSIS packages which used DFT (Only Source and destination) and Execute SQl task in Sequence container (25 in each package). I need the error to be logged only when package fails. I do not wish to include event handler for every task to capture error. The error whcih has to be logged be the exact reason like what we see in execution results e.g "Failure on column abc on data row 234 due to truncation".
2. I have 15 packages executing in a job and need to implement Package restarting from the point of failure , I thought abt checkpoints but seems that it behaves differetly in DFT.
Any alternate approach is very much appreciated...
Appreciate help !!
October 2, 2012 at 3:14 pm
you need to customized your package in such a way that only you get the error with it's related description.
you can use some in built function of SQL SSIS, and escalate the error to the flat files or some sql tables.
you can try using CHECKPOINT with condition in SSIS to restart your package when it fails and from the point it fails.
Good Luck...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply