SSIS Update carchar包含gibberish
我有一个使用SSIS带到Oracle的DB2表。 该表具有varchar列，可以包含带有®之类的字符的jibberish，然后负载失败了尝试将这些不良值存储在varchar中。
我已经通过将Oracle的目标字段更改为NVarchar来解决此问题，该字段是Unicode并处理“坏”字符。
但是，这还不够，因为该过程继续使用其他无法处理gibberish的工具。
我的目标是在SSIS/Oracle中识别这些字段，并将其更新为无效。
答：Oracle是否有办法检查字符串是否包含CHAR/VARCHAR数据类型不接受的字符？
B. SSI中有没有办法尝试/捕获不良字段转换并更新这些字段，而不是将记录扔到其他表格上？
谢谢你！！您的帮助将不胜感激。
I have a DB2 table that I bring to oracle using SSIS.
This table apperantly has varchar columns that can contain jibberish with characters like ®, and then the load fails trying to store these bad values in a varchar.
I've solved this by changing the destination field in oracle to be Nvarchar, which is unicode and handles the "bad" characters as well.
However, this is not enough, because the process continues to other tools that can't handle the gibberish.
My objective, is to identify these fields on-the-fly in SSIS/Oracle and update them to be NULL.
A. Is there a way in ORACLE, to check if a string contains characters that char/varchar data types won't accept?
B. Is there a way in SSIS to try/catch bad FIELDS conversions and UPDATE these fields, instead of throwing the record to a different table?
Thank you!! Your help will be much appreciated.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论