In my case, I am getting the data from a SP and dumping it into a text file. I need the text file to be Code Page 65001 (UTF-8) per client request.

The problem was one of the fields in my SP was of type char, I did a cast to nvarchar(1) and then I was able to set the Code Page to 65001.

Thanks