May 16, 2013 at 7:49 am
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
Does your text file connection in SSIS think that the top row is the header row?
John
May 16, 2013 at 8:01 am
Are you using a Data Flow Task? Or, a Script Task?
May 16, 2013 at 8:53 am
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