• SSIS does have data type suggestions but only in design mode iirc. Once you setup your metadata it's set.

    You could do some of the checks yourself using the new TRY_CAST and TRY_PARSE functions to see if a particular column contained data that would be acceptable if you tried altering the data type.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato