SSIS Package not reading the last row in flat file

问题:

I have SSIS Package which will load .EXT file into my Database table.

The package Flat File connection manager Editor properties are
   Format: Ragged Right
   Code Page: 1252 ANSI (Latin-I)
   Text Qualifier: <None>
    Header Row Delimiter: <LF>

While trying to preview the file before loading, i am able to see all the rows in columns and preview tab of Flat File connection manager Editor.

But in actual loading of the file, last record alone is not getting imported into table. It was loading fine and still it is processing the file on daily basis. Only for two days file, it was not imported last records. I am trying to find the root cause.

I suspected something wrong with the file, but i do not find any differences between the working and not-working version of files.

Please suggest us to resolve the same. Kindly let me know if any informations required.

回答1:

I ran into the same issue and did some research to find a solution that worked from me. Apparently the SSIS package had gone through a conversion from an earlier version at one point. When the conversion was done, the text qualifier property on the flat file connection was mangled. It had originally been <none>, but the conversion changed it to _x003C_none_x003E_. I opened the flat file connection manager and changed the text qualifier property on the general tab back to the proper value of <none>.

Credit goes to this thread for providing the answer.

回答2:

I had a similar issue. My flat file didn't had any text qualifiers. When i added a text qualifier the package ran successfully. My guess is that the file is read as text and the CRLF is not recognized at the last line.

回答3:

If you can provide a sample of the data from the file