最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

sql server - Facing an issue with converting string to decimal using derived column transformation in SSIS - Stack Overflow

programmeradmin5浏览0评论

I am having file with data like

COLA,COLB,COLC
James,198.87,09
Jack,32.7,78
Philips,0.0,98
Jacob,0,76

I am trying to use Derived Column transformation to get value in COLB like 198.87,32.70,0.00,0.00. I have tried with different ways to convert and everytime getting error like expression error

LEN(TRIM([COLB])) == 0 ?" ": (iSNULL( (DT_DECIMAL,18,2) [COLB]) ? " " : (DT_WSTR,10) (DT_DECIMAL,18,2)[COLB])

If I remove DT_Decimal there is no expression error, How can I achieve the output using any other functions. i tried with Round function but still error.

Error at Data Flow Task [Derived Column [96]]: Cannot parse the expression "LEN(TRIM([COLB])) == 0 ?" ": (iSNULL( (DT_DECIMAL,18,2) [COLB]) ? " " : (DT_WSTR,10) (DT_DECIMAL,18,2)[COLB])". The expression was not valid, or there is an out-of-memory error.

与本文相关的文章

发布评论

评论列表(0)

  1. 暂无评论