Why is my SSIS text logfile formatted in this way?

2019-08-31 09:29发布

问题:

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:

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

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.

Thanks in advance.

回答1:

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