Do you know there are hundreds of additional tasks, tools, and components for SSIS, many which are free? Why re-invent the wheel? Take a look at this exhaustive list created by Todd McDermid on CodePlex: SSIS Community Tasks and Components. It is split into the following categories:
- Tools
- Connection Managers
- Log Providers
- Tasks (for Control Flow)
- Foreach Enumerators
- Script Task
- Script Samples
- Components (for Data Flow)
- Script Component Samples
- Sources
- Transforms
- Destinations
Chances are you will find something useful right away. At the very least, if you read this list then next time you are developing an SSIS package you might remember a task that will come in handy.
