Designing a Custom Control Flow Task
To determine whether, in a given situation, you actually need customization or not, you need to ask yourself two questions:
- Can the required operation be performed using one or more natively provided tasks or components in an efficient way that will remain scalable and not compromise the maintainability of the solution?
- Would the given operation only be needed in this one particular situation, or is it reasonable to expect that a similar operation might be required elsewhere, or at a later time?
If using the built-in features to address an otherwise unsupported requirement might negatively affect the efficiency of the solution, reduce its scalability, or increase its complexity, then customization should certainly be considered.
In SSIS, you can implement your own programmatic logic by using two different techniques – both built into the platform: by providing the custom code in a Script Task or a Script Component, or...
