sgeiger 71434 (7/18/2012)
I think that using the example of a MsgBox in a script task sets a bad precedent. SSIS was never intended to be an event driven process. I agree the script tool is powerful but not for interrupting data flow with events that require user intervention.
We disagree. And that is ok.
One important note: this is the control flow, not the data flow. The control flow is a workflow engine and each task generates events, some of which trigger additional operations. The control flow was designed to facilitate such interruptions.
Andy
Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics