I have a package which imports data from excel to sql server.
- Excel file has a column with first x rows are numeric and the remaining values are varchar
- Derived column task to convert to string
- Destination table is varchar
Here's where I am scratching my head.. When I look at the advanced properties for the excel source task, the in/out datatype is picked up as double precision float. The entire data set successfully loads into my destination table however all the string values are populated as NULL, instead of erroring out at the excel source task.
I can ultimately solve this issue by formatting the column in excel as text but my question is, why the package does not error out? Please let me know if I'm missing any important details.