'SSIS When viewing query preview some characters are replaced

I have huge amount of data in Sybase DB and I made OLE DB connector in SSIS where I succesfully connected it. We are using charset = cp1250, because we have data from center europe.

DATABASE: Sybase Program: Visual Studio 2017 SSIS Connector: OLE DB

The Problem: when I view some data from my select I can see that it somehow replaced , but only two characters (character - ř and character č) with arrow pointing to right. I even set extended properties to: charset=cp1250. corrupted data

Does anyone know what to do? Or hwere to look at? I am completly lost after two days of searching and trying to fix that.

Thanks for any advice.

sqlssisoledbsybase


Solution 1:[1]

I managed to solve my problem.

The solution was to create new ODBC connector and replaced OLE connector. I also have to change some settings. In advance settings, I have change

  • Language > us_english
  • Communication charset > Client charset
  • client charset > other > cp1250

I hope someone it will find usefull :)

Sources

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

Source: Stack Overflow

Solution Source
Solution 1 JFpoj

Related Questions