If you're just looking to handle nulls, there's a third party data flow component called "Null Manager" from Tactek Data Systems (www.tactek.com). It's for SSIS 2008 only but it's cheap...