Viewing post 1 (of 1 total)
You can try change connection settings to Excel in SSIS.
In Extended properties change "Excel 12.0" -> "Excel 12.0;IMEX=1"
Then all rows from Excel are datatype Unicode string 255 (DT_WSTR). So import...
February 10, 2012 at 2:16 am
#1445406