Home
Blogs
DBAs@Midnight
Admin
Dev
Midnight Snacks
All Vids
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:

Ground Zero SSIS: Class 1
SSIS Scripting Languages
Commenting Tribal Knowledge in SSIS Packages
Row Count Transform
Troubleshoot SSIS: "Script component cannot build user component"