Home Forums SQL Server 2005 SQL Server 2005 Integration Services Excel Datasource brings in a couple of numeric fields as nulls? RE: Excel Datasource brings in a couple of numeric fields as nulls?
Hans Lindgren
SSChampion
Points: 10496
More actions
July 25, 2006 at 7:51 am
#651338
...and if the Excel team hasn't fixed the bug with the 'guess rows' parameter you should watch out for wrong data anyway. If the Excel Import determines that one column is VARCHAR it will replace any cells containing just numerics with NULLs...