Post reply

One row not importing in SSIS package

  • 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

  • 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

  • May 16, 2013 at 8:01 am

    #1615804

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

  • May 16, 2013 at 8:53 am

    #1615842

    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