I give MS a hard time sometimes so I like to give them props when I find something really worth it. And here I discuss 3 new features in Katmai that are mainly for DBAs. They’re really cool so pay attention and enjoy. Here’s the vid.
Author: KenpoDBA
Creating Files with ForEach Loop
Here I take the intro one step further and show you how to create multiple txt files based off of a looping variable in the ForEach loop container. This is a very common task and I see this question quite a bit in the forums, so I documented it. Here’s the vid.
Introduction to Sequence Containers
This video takes a look at the basics of using the Sequence Container in SSIS. There’s not a lot to it, but it’s a good intro if you don’t know what it is. Here’s the vid.