SSIS tips & tricks. Peter Doyle. File Formats . Identify the file formats correctly Notepad2.exe seems good for identifying UTF-8 versus ANSI Beware processing an ANSI file as UTF-8 as you will lose characters like umlaut ü and accented é XML default format is UTF-8. Embedded quotes.
SSIS tips & tricks