如何在SSIS派生列中将unicodestring值乘以100? [英] How to multiply unicodestring value by 100 in SSIS derived column?

问题描述

如何在SSIS派生列中将unicodestring值乘以100?

How to multiply unicodestring value by 100 in SSIS derived column?

推荐答案

您不能将字符串与数字相乘. 使用数据转换任务将字符串转换为数字，然后乘以100.
如果只希望unicode字符串输出，请使用另一个数据转换任务将数字转换回字符串.

You cant multiply a sting with number.
Convert the string to number using data conversion task and multiply with 100.
If you want only unicode string output use another data conversion task to convert number back to string.

这篇关于如何在SSIS派生列中将unicodestring值乘以100?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！