I am trying to load data from Excel. Certain columns can have numeric and alpha numeric data (EG: ORder Number could be "1233" or "ABC-123"). The destination is of varchar data type. When I run the SSIS if the data in the first row for the column is alpha numeric ("ABC-123") the SSIS loads both the alpha numeric and numeric data. But if the first row is numeric then it ignores alpha numeric (loads NULL instead of alpha numeric).
How can we fix that?
Thanks
Sreejith