@Vandy

did u reenter the data after setting the excel column as text

instead of using the trnasform data task use the execute sql task and pass the global variable values by using ?

My guess is that excel autmatically decides on the data type and hence if it finds a numeric datatype in the first 8 rows it assumes that the remaining rows...