在平面文件连接中设置多个行定界符 [英] Set multiple row delimiters in Flat File Connection
问题描述
我们可以在SSIS中为平面文件连接设置行定界符。但是问题是如何将平面文件连接的多个行定界符设置为不为此使用脚本组件?
We can set a row delimiter for a Flat File Connection in SSIS.but the question is how to set multiple row delimiters for a Flat File Connection to not using Script Component for this?
例如包含以下字符串的文本文件:
for example for a text file containing this string:
那只敏捷的棕色狐狸跳过了懒狗。
The quick brown fox, jumped over the lazy dogs.
我想要这两个使用,','和'。'作为行定界符后的行:
I want to have this two rows after using ',' and '.' for row delimiter:
快速的棕色狐狸
The quick brown fox
跳过了懒狗
推荐答案
简短的答案是,普通的平面文件连接管理器没有该功能。
The short answer is that the stock Flat File connection manager doesn't have that capability.
坦率地说,我很难想象一个业务情况,有人在向我发送带有不一致行分隔符的平面文件中的数据。但是,如果遇到这种情况,我将使用脚本组件,就像@billinkc对您先前的多个行定界符问题。
I frankly am having trouble imagining a business situation where somebody is sending me data in a flat file with inconsistent row delimiters. But if I did run into that situation, I'd use a script component, along the lines of @billinkc's answer to your earlier Multiple row delimiters question.
这篇关于在平面文件连接中设置多个行定界符的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!