SQL Server Performance

SSIS BUG: First cell null in Excel source

Discussion in 'SQL Server 2005 Integration Services' started by L0st_Pr0phet, May 28, 2010.

  1. L0st_Pr0phet Member

    I have a weird problem, that seems to me is a bug in SSIS and I was wondering if anyone else has come accross it or has a fix.
    I have created a simple SSIS package to import from a 2003 excel spreadsheet. The first column is a date field, now when the first cell in the first column in the spreadsheet in null then no values for the whole column are imported. If I put a value in that first cell, then the rest of the columns data imports fine.
    Does anyone know a way round this?
    ( I actually over simplified this.....if there are nulls in the first column for the first 200 say then it doesnt import any data for that column)
  2. satya Moderator

    By default it is handled the NULL based values, but you have a mappings section where you can relate the column to column

Share This Page