Summary

This chapter has focused on building tasks and components to be configurable. SSIS tasks and components are even more powerful when they are designed so that they can be reused within other packages. When designing packages, it is good practice to use variables when there is a need to hold configuration settings. Tasks can then be configured to function differently within different packages and environments.

Not only are reusable tasks important, but creating reusable code is even more important. The examples in this chapter have shown how scripts can be extended by reusing custom functionality within assemblies. By extending SSIS scripts to use custom assemblies, custom logic is encapsulated into assemblies and referenced, rather than embedded within the script. The logic becomes easier to maintain, although, at the same time, allows more than one person to technically work on building scripts during a given time.

Now that you understand how to extend SSIS through scripts, you are ready to tackle extracting data from sources.