Hello Experts, I have a stored procedure exporting pipe delimited files using
"EXECUTE @hr = sp_OAMethod @objFileSystem , 'OpenTextFile' , @objTextStream OUT , @FileAndPath,8,true"
The fields are declares as nvarchar(max), but data is not exporting. When I declare fields as VARCHAR, the data exports, however the Chinese characters come out as "?????"
Please let me know if you have a solution to the issue.