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.

Forcing Package Failures

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.

Connection strings in Package Config Files

Here I show you how to put your data source connection string inside a package configuration XML file.

This was inspired by a forum post by a user so I decided to make a video for him.

 Here's the Video.

Real news, real tech.