SSIS 使用的点击流数据的推荐列分隔符
我正在处理一些点击流数据，我需要向供应商提供有关 SSIS 使用的首选格式的规范。
作为文本文件中的 URL 数据，您会推荐使用哪个列分隔符。我在想管道“|”但我意识到管道可以在 URL 中使用。
我做了一些测试来指定多个字符作为分隔符 lile |^|但是当我创建平面文件连接时，SSIS 中没有选项。我已经输入了这些字符。但当我去编辑平面文件连接管理器时，它已更改为 {|}^{|}。这让我对导入成功感到紧张。
我只是想看看是否有人对使用哪个安全列分隔符有好的想法。
I am working with some click stream data and i would need to give specifications to the vendor regarding a preferred format to be consumed by SSIS.
As its URL data in the text file which column delimiter would you recommend. I was thinking pipe "|" but i realize that pipes can be used within the URL.
I did some testing to specify multiple charecters as delimiter lile |^| but when I am creating a flat file connection there is not option in SSIS. I had type these charecters. But when i went to edit the flat file connection manager it had changed to {|}^{|}. It just made me nervous to the import succeeded.
I just wanted to see if anybody has good ideas as to which would safe column delimiter to use.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
制表符分隔可能相当安全，至少假设“点击流”指的是 URL 列表或类似内容。但从理论上讲，只要供应商正确引用数据，任何分隔符都应该没问题。
Probably tab-delimited would be fairly safe, at least assuming that by "clickstream" you mean a list of URLs or something similar. But in theory any delimiter should be fine as long as the supplier quotes the data appropriately.