Andy Brownsword looks for slow performers:
Performance issues in SSIS packages can be tough to track down. You know something is off but trawling through pages of SSIS reporting and the validation noise is frustrating. Adding your own logging is a nice idea but not feasible at scale.
An alternative?
Read on for Andy’s alternative, including a rather useful-looking script.