Script(s)

technology as-is

October 7, 2010
by gchandra
0 comments

SSIS import mixed datatypes from Excel to SQLServer

While importing data from Excel to SQLServer, if a Excel column in has both Text and Numeric values then either Text or Numeric values will be NULL in SQLServer. See example.. If first data cell (in Excel) in that particular … Continue reading