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

    Hi,
    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)
    stew
    L0st_Pr0phet, May 28, 2010
    #2

  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
    satya, Jun 21, 2010
    #3

Share This Page