This question was asked here. SSIS Package not reading the last row in flat file
I believe I have some extra perspective on it. I have a SSIS package that does simple data flow task which loads Flat file to Sql Server. The file has a Header, 5000 data row, Footer.
Right off the bat, the package throws the warning "Partial end of the file". Clearly something is different about the file, but I can't tell what.
Ran through VS STUDIO 2008 - Loaded 5000 rows [ GOOD]
Ran through SQl server agent [ 32 bit, 64 bit] - Loaded 5000 rows [Good]
Ran through UC4(DTEXEC command [64bit, 32 bit] - Loaded 4999 rows [ Bad]
My next move was, I took the last row and I placed it somewhere in the middle, The DTEXEC loaded 5000 rows. Well, that just tells me, there isn't anything wrong with the last row.
Any Ideas