且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

SSIS脚本组件以删除CHAR(n)字段中的“\0”charachers

更新时间:2023-12-05 18:20:40

考虑炭(4)变换为二进制表示(使用数据转换组件),则操作从那里的各个元素。如果可能的话,将其丢在源查询,以便它已经二进制进入管道前。

Consider converting the char(4) to a binary representation (using Data Conversion component), then manipulating the individual elements from there. If possible, cast it in your source query, so that it's already binary before it enters the pipeline.