为什么我的 SSIS 文本日志文件以这种方式格式化? [英] Why is my SSIS text logfile formatted in this way?

问题描述

我已使用文本文件日志提供程序在我的 SSIS 包中配置日志记录.提供程序的连接字符串是我本地文件系统中的文件名.包完成并写入数据到日志中，但它的格式是我没想到的:

I have configured logging in my SSIS package by using the Text File log provider. The connection string for the provider is the name of a file in my local file system. The package completes and writes data to the log, but it is formatted in a way that I did not expect:

如果我在 Notepad++ 中打开它，它看起来更糟:

If I open it in Notepad++, it looks worse:

这就是它的样子吗?或者我忽略了 SSIS 中的一些配置设置?Notepad 和 Notepad++ 显示其他文件没有任何问题.

Is this just the way it is? Or is there some configuration setting in SSIS that I'm overlooking? Notepad and Notepad++ aren't having any issues displaying other files.

提前致谢.

推荐答案

好吧，我想我已经解决了.这是 ssis 2008.我想如果你先在日志文件中放入一些字符，然后运行 ​​ssis 包，你就会得到这个 unicode 输出，字符之间的空格问题.如果您遇到此问题，请删除日志文件中的所有内容，将文件保存在记事本中为ansi"，然后再次运行您的程序包，这一次您的文本日志文件将看起来正常.我想如果你混合使用 ansi 和 unicode 字符，记事本会变得混乱.

Ok, I think I figured this is out. The is ssis 2008. I think if you put some characters in the log file first and then run the ssis package you have this unicode output, space between characters problem. If you are having this problem, delete everything in your log file, save the file in notepad as "ansi" then run your package again and this time your text log file will look normal. I think if you mix ansi and unicode characters, notepad gets confused.

这篇关于为什么我的 SSIS 文本日志文件以这种方式格式化?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！