One row not importing in SSIS package

  • 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

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

    John

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

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply