SSIS 正在删除平面文件源导入的记录 [英] SSIS is dropping a record on flat file source import

问题描述

我在 SSIS (2008) 中遇到一个非常奇怪的问题.

am experiencing a very strange issue in SSIS (2008).

基本工作流程如下..

使用平面文件源 (CSV)，导入 SSIS，推送到 SQL.

Using a flatfile source (CSV), bring into SSIS, push into SQL.

当进程在开发环境中运行时，一切正常.

当使用完全相同的平面文件源将 dtsx 包置于生产环境中时，文件中的最后一条记录将被删除，直到它开始 SQL 过程.

When the dtsx package is placed in production.. using the exact same flat file source, the last record in the file is dropped by the time it gets to the start of the SQL proc.

已经讨论了我能想到的所有内容，包括行分隔符、列分隔符、重建平面文件源连接.

Have gone over everything i can possibly think of including line delimiters, column delimeters, rebuilding the flat file source connection.

有没有人见过这样的东西?

Has anyone seen anything like this before?

CSV 文件包含 10 条记录并有 4 列.以逗号分隔，以 {CR}{LF} 分隔行.该文件由 Excel 生成，CSV 文件末尾有一个空行.

The CSV file contains 10 records and has 4 columns. It is comma delimited and line delimited by {CR}{LF}. The file was produced by Excel and has a blank line at the end of the CSV file.

如果需要更多信息，请告诉我.我不确定我还能提供什么.

Let me know if more information is required. Im not sure what else i can offer.

推荐答案

我遇到了完全相同的问题.我发现，当我将 SSIS 包从一台服务器复制到另一台服务器时，有时平面文件源的文本限定符会搞砸，而不是 <none>它将有 _x003C_none_x003E_.一旦我确定没有记录被丢弃.

I had this exact same problem. What I found out was that when I copy an SSIS package from one server to another sometimes the text qualifiers for flat file sources get messed up, so instead of <none> it will have _x003C_none_x003E_. Once I fixed that no records were dropped.

这篇关于SSIS 正在删除平面文件源导入的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！