查看查询预览时的SSI替换一些字符
我在Sybase DB中有大量数据,并且在SSIS中制作了OLE DB连接器,并在其中成功连接了它。我们使用Charset = CP1250,因为我们有来自欧洲中心的数据。
数据库:Sybase 节目:Visual Studio 2017 SSIS 连接器:Ole db
问题: 当我从选择中查看一些数据时,我可以看到它以某种方式替换了,但是只有两个字符(字符-I和字符č),箭头指向右侧。我什至将扩展属性设置为:CharSet = CP1250。 损坏的数据
有人知道该怎么做吗?或在?经过两天的搜索并试图解决这个问题,我完全迷失了方向。
感谢您的建议。
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.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
我设法解决了我的问题。
解决方案是创建新的ODBC连接器,更换了 ole Connector。我还必须更改一些设置。预先设置,我有更改
希望有人会发现有用的:)
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 :)