Export Flat File from SQL Server for AS400 System to Consume (with Code page 65001(UTF-8) )


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.

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s