SSIS - 平面文件连接管理器损坏 [英] SSIS - Flat file connection manager corrupted

问题描述

我有一个平面文件连接管理器，它有超过 800 列以固定宽度格式定义，直到昨天都运行良好.当我现在用这个连接管理器打开一个平面文件时，我看到那些我认为在数据中引入空格导致问题的黑色方块.什么可能导致这种情况?除了它指向新文件之外，我上次访问它时没有更改任何内容.我确实使用新的连接管理器检查了新文件，看起来没问题.没有 Square 框，所以它是连接管理器.我不想重做连接管理器，因为它有 800 列并且定义这些列将花费很长时间.请帮忙！

I had a flat file connection manager with over 800 columns defined in Fixed Width format that was working fine until yesterday. When I now open a flat file with this connection manager I see those black squares which I think are introducing spaces in the data causing issues. What could have possibly caused this? I did not change anything from the last time I accessed it except that its pointing to the new file. I did check the new file with a new connection manager and it looks ok. No Square boxes so its the connection manager. I do not want to redo the connection manager since it has 800 columns and defining those will take forever. Please help!

谢谢.

推荐答案

我不知道发生了什么本身，但你在那些黑盒子里看到的是控制提要/换行，也就是 cr/lf.您暗示源文件长度增加的提示是文件下方的常规对角线.所有字段都被移动了 2 个字符.如果您知道您的源数据总是会像这样输入，那么我会在平面文件连接管理器 ABC 的末尾再添加一列.将其定义为长度 2，称之为 ignore 或类似的东西.在您的平面文件源中，在数据流中，甚至不要将字段映射到数据流中.

I don't know what happened per se, but what you are seeing in those black boxes are a control feed/line feed aka cr/lf. Your hint that the length of your source file has increased is that regular diagonal line going down the file. All the fields have been shifted over by 2 characters. If you know your source data is always going to be coming in like this, then I'd add one more column to the end of the Flat File Connection Manager, ABC. Define it as length 2, call it ignore or something obvious like that. In your Flat File Source, in the data flow, don't even map the field into the data flow.

这篇关于SSIS - 平面文件连接管理器损坏的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！