Jen McCown

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.

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.

This one was by user request to show how you can compare the counts of 2 tables and use it to force the package to fail if the counts don’t match.

This comes in handy when comparing the counts of the source and destination tables after your load.  The scenario is specific but can be modified to anything you like. 

Here's the vid.