One row not importing in SSIS package

• jman76

  Hall of Fame

  Points: 3388

  More actions

  May 16, 2013 at 7:49 am

  #150363

  I am trying to import a text file into a SQL Server table.

  My package runs fine and imports the data into the table, however I am finding that it is not importing 1 row.

  For instance the total number of rows processed is 56610 and the SSIS Pipeline Information wrote 56109.

  Does anyone know how I can resolve this, so it imports all the rows.

  Thanks

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  May 16, 2013 at 8:01 am

  #1615803

  Does your text file connection in SSIS think that the top row is the header row?

  John

• cafescott

  SSCarpal Tunnel

  Points: 4724

  More actions

  May 16, 2013 at 8:01 am

  #1615804

  Are you using a Data Flow Task? Or, a Script Task?

• jman76

  Hall of Fame

  Points: 3388

  More actions

  May 16, 2013 at 8:53 am

  #1615842

  Thanks Guys. Cant believe i missed that. It was the column names in first data row.