I gave a presentation at today’s SQL Saturday in NY on replacing SSIS with PowerShell.
You can view the presentation, or see below for the two second summary:
- SSIS is a terrible development tool
- Many SSIS features can be built with out much effort with PowerShell, C#, and the TPL
- See the demos
The code is hosted at http://psis.codeplex.com/ Currently it has the following capabilities
- Concurrent bulk data transfer
- Single pass star-schema populator
Contact me if you’d like to contribute or collaborate on this.