Home Forums Data Warehousing Integration Services [Flat File Source [1]] Warning: There is a partial row at the end of the file. using 2008 R2 RE: [Flat File Source [1]] Warning: There is a partial row at the end of the file. using 2008 R2

  • May 3, 2015 at 9:00 am

    #1795240

    Then my suspicion is that the scrubbing step is the culprit, have you tried to append a single empty line to the file after the scrub?

    and yes, 2 days ago I tried a blank line (used 13 commas on the line following last line in the file)

    thanks Andrew at this blog http://blog.andrewjudd.ca/category/sql/ssis/

    and that seemed to be fixed the problem, until I reran the ssis package. I don't know what else I might have done afterward, but the next time I reran I got same issue, even though the 13 commas were still in the raw pre-scrubbed file. So, I decided to pull the files freshly from the ftp server and unzip them and added the 13 commas again and apply my scrub but no more success with blank line.

    If you have better way to scrub the file I would like to try it but it otherwise works for all 43 of my raw files (all using my derived column solution).

    --Quote me