I have an excel file with one column. It can have date or number or text.

In the ssis data flow task I use the Excel data source task to read the excel file, and then I store this into a SQL table column of type nvarchar(1000).

Now the problem seems to be that based on the first 8 values in the excel columns, ssis dynamically detects the type. If it detects it as a number, then, when it reads the column it treats the text values as nulls.

I think the solution is to change something in the excel data source takes advanced editor (external columns / input columns settings), but I can’t figure this out. Can someone guide me with this.