You are not logged in.
I am trying to insert some data from a CSV file to a SOAP web service and I am having problems with the characters passing to the Web Service. Basically, I have the CSV file set to UTF-8 character set and the preview of the file looks normal. I then setup a dataflow to a tLogRow and the characters come out as ?????. Any help is appreciated.
Hi Pedro --
Apologies for taking so long to get back to you and thanks for your prompt reply, I have been very pleased with the level of assistance and assistance I have received from the community.
I have checked the encoding is set to UTF-8 in the delimited input advanced settings. I have taken some screenshots for your review.
Please show us the encoding of this csv file.
To get the encoding of a csv file, you might follow these steps.
1: Change the suffix of this csv file into txt.
2: Open this txt file and select File->Save as.
3: A "Save as" window appears. Change the encoding drop-down list into UTF-8.
4: Change the suffix of this file back to csv.
Then try your job again.
Does it work fine?
Hi Pedro --
I have performed the steps you outlined and the output has produced the same result. I have uploaded the file incase you want to give it a try yourself and see if you have the same behavior.
Strike that I cannot upload the file so if you would like me to email it, let me know and I can send it to you.
Last edited by webarnes99 (2012-06-06 05:32:32)
Which version of TOS do you use?
I test it under TOS 5.1.0 and WINXP.
It works fine as the following image no matter what encoding I select.