'Non-Unicode Characters Change after SSIS process

Using SSIS, I try to extract data from some source to MSSQL. Since the data is in Turkish, there are some letters that don't exist in English such as 'İ','Ş','Ğ','Ç' etc. When this data is conveyed to MSSQL, these characters turn into either '?' or 'Y'. This is the summary of the situation and I have two questions.

1- We have two servers. First is the test server in which I come across with no problems. The non-english characters goes into SQL as they were in the source. SSIS process doesn't change the letters. However, in the other server I have this problem. What difference between two servers ( either in MSSQL or in Visual Studio settings) might cause this ?

2- The same problem occured like a week ago for just one column. By adding a data conversion step in SSIS, I changed the column data type from string to unicode string and that solved my problem. However, this time I have a dozen of columns and I wonder if there is any way to solve the root problem rather than changing the data types one by one. Because if this problem is seen in another table, I will have to do it all over again.

Thanks for your time and your replies.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source