Watching 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.

 

Author: Sean McCown

Filmed: 6/27/2008

Length: 13:20 minutes

Size: 30,246 KB

Click here to download the video!