Home
Blogs
DBAs@Midnight
Admin
Dev
Midnight Snacks
All Vids
Podcast
Events
Contact
Links
NTSSUG

Leave a comment.

Name:
Email:
Comment:
(500 chars.)

0 of 500.
What's the picture?



Forcing Package Failures


Author: Sean McCown
Date: 06/27/2008
Length: 13:20
Size: 30,246 KB

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.

Right-click to download video

Others in Series:

You might also like:

SSIS Basics 2: Flatfile Olympics
Connection strings in Package Config Files
Derived Columns
SSIS Using Variables in Script Tasks
SSIS Scripting Languages