I have an Execute SQL Task that reads columns as strings but can be null. I feed the information in the result set to a foreach loop container and when nulls are encountered the package dies there. Is there an easy way to deal with this other. I have changed all of my null possible columns to object types but I don't want to do this for all of the possible null columns.
Thanks