SSIS 包未读取平面文件中的最后一行 [英] SSIS Package not reading the last row in flat file

问题描述

我有 SSIS 包，它将 .EXT 文件加载到我的数据库表中.

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.

推荐答案

我遇到了同样的问题，并做了一些研究以找到对我有用的解决方案.显然，SSIS 包曾经经历过从早期版本的转换.转换完成后，平面文件连接上的文本限定符属性被破坏.它最初是 ，但转换后将其更改为 _x003C_none_x003E_.我打开了平面文件连接管理器并将常规选项卡上的文本限定符属性更改回 的正确值.

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>.

感谢 此线程 提供答案.

这篇关于SSIS 包未读取平面文件中的最后一行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！