My second post of the day at Alabama Code Camp 6 in Huntsville is “Introduction to SQL Server Integration Services”.
The slide deck is here: Intro to SSIS Slide Deck
The “cheat sheet” or script I used to do the demo is here: Script for doing the SSIS Demo You can step through it to recreate all of the things I did in the demo today.
Finally here is the finished project. It’s actually zipped, but my current host doesn’t like zip extensions so when you download it change the extension from txt back to ZIP. Finished SSIS Project