Export Flat File from SQL Server for AS400 System to Consume (with Code page 65001(UTF-8) )Posted: March 10, 2017
I have a client request for a csv file from our system to consume in their AS400 system.
The request was side-tracked by to remove the last non-visible line at the end of the file.
The real problem is the encoding issue. The default encoding from our Windows (2012) system is 1252(ANSI -Latin I).
First I tried Code Page 437 but it didn’t work.
Finally I switched the encoding to Code page 650001(UTF-8) from the Flat File Connection Manager,
and it seems the file works in the third party environments.