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.
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
I hope someone it will find usefull :)
