Greetings - I need your help.
I have an SSIS package with a
Data Flow Task which has the following Data Flow tasks:
Excel Source ->
Data Conversion ->
SQL Server Destination .
The data in my Excel worksheet contains strings as well as numbers. (Also has some blank cells.)
I'm trying to cast all data into strings and insert it into a SQL table, but the numerical data doesn't get inserted -- I get null instead.
I've casted the worksheet data to
Unicode string [DT_WSTR] and mapped the casted fields to my SQL table but still get null for the cells containing numbers. All fields in the SQL table are varchar.