• I actually figured this one issue out. If you right click on the Flat File Source in the data flow task, there is a tick box with the info:

    Retain null values from the source as null values in the data flow.

    If you select this data with Null values are then imported