Although there is a “3rd party developer ecosystem” for SSIS components, it’s not particularly active. I don’t know if this is because there’s no interest, if people just don’t understand the platform well enough, or if the SSIS product group just did such a good job building the core platform that people don’t see the need to turn to 3rd party vendors (or perhaps some other reason entirely) but I don’t see a ton of add-on components out there.
But CozyRoc has just announced beta versions of a set of interesting-looking control flow and data flow components, including:
- Package SSIS Connection Manager – Provides access to the current or different package at runtime.
- Data Flow Source SSIS Data Flow Component – Very fast, non-blocking, in-memory data read from another data flow.
- Data Flow Destination SSIS Data Flow Component – Exposes data from a data flow for in-memory read in another data flow.