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 […]
Author: KenpoDBA
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.
Introduction to Schemas
This is an excellent video that explains what schemas are and why you should care. Here’s the Vid.