SSIS onerror event. Execute SQL task just sits there
I have an execute sql task that executes within the package level onerror event. The task will run just fine if it's not within the开发者_C百科 onerror event, however, if it's sitting in the flow for the onerror event, it just turns yellow, and does nothing.
I have a file task that will complete just fine as well within the onerror event.
SSIS 2008 R2
Thanks,
I ended up using the OnTaskFailed handler instead. That seemed to fit my requirements as much as the OnError event.
精彩评论