Dries Van Hansewijck
Dries Van Hansewijck

Reputation: 1454

Which encoding does Microsoft SSIS use to output flat files in Unicode?

In the Flat File Connection Manager screen there is a checkbox to specify that the file is encoded as Unicode, but there is no way to tell which encoding will be used (UTF-8, UTF-16, ...)

Is there an official Microsoft resource as to which encoding is used?

Upvotes: 0

Views: 1044

Answers (1)

Ignacio Vazquez-Abrams
Ignacio Vazquez-Abrams

Reputation: 798746

"Unicode" in Microsoft products tends to be UTF-16LE.

Upvotes: 2

Related Questions