Geeks With Blogs
Jim Giercyk April 2013 Entries
Adding a Control Flow to SSIS Event Handler
In a complex SSIS Control Flow, there is often a need to have a common last step, regardless of the number of Control Flow end points. Consider the following example: In this case, we are using the Completion constraint (blue line), and an Expression to determine which path to follow. If there are records, we upload them, if not we end without doing anything. In either case, we are writing a message to a log table, recording the event. As simple as this example is, we have 2 end points. Now, what ......

Posted On Friday, April 12, 2013 11:02 AM

Copyright © Jim Giercyk | Powered by: