It depends on how you change your excel sheet. I think SSIS scans the first 10 (or so) rows to determine the column data type. Say you have column A containing numeric values in these cells SSIS sets the DT_UI4 or so. If you change one cell to an alphanumeric value SSIS thinks the metadata has changed to DT_WSTR.