Scripting Patterns - SQL Server Integration Services Design Patterns - page 111

Figure 3-6 . Script component configuration
Note You should consider the selection of the Script component role (transforma-
tion, source, or destination) to be permanent. If you mistakenly select the wrong config-
uration role, it's usually easier to delete and re-create the script instance rather than try-
ing to reconfigure it.
Chances are good that you'll use the Script component in each of these roles
(source, transformation, and destination) from time to time. However, my experience
has been that transformation is the most frequently used role for the Script component.
Script Maintenance Patterns
Designing custom logic in your ETL processes is a hard, but rewarding, task. However,
the job is not done once the code is promoted from development to testing or even to
production. The effective ETL architect maintains a long-term vision when designing
script solutions, because the packages often survive well beyond the tenures of those
who create those solutions.