How to resolve if the Special characters are changed when loading the data from excel file to SQL table
I have a scenario as below.
My source is excel file and which is having customer master data. In that Name1 filed is having some special characters (symbols which are not part of our keyboard, like company registered symbol, R in the circle, pound symbols) .
The above data when I am extracting from the excel file and loading into my Target SQL server table, the special characters (symbols) are getting changed.
Only the special charaters are getting changed and remaining characters are displaying as expected.
I tried to resolve this by saving the excel file encoding as UTF-8 and creating the Target datastore code page and server codepage using UTF-8, but no luck.
Please suggest me how to resolve this issue.