SSIS and Excel Missing Data

Wiring up to Excel in SSIS can be a pain. Check out my screencast - it might assist next time you get missing data.