如何从excel加载％值到ssis包中的sql表 [英] How to load % value from excel to sql table in ssis package

问题描述

我正在从excel表读取数据到sql table.i在列表中有一个列名为'traffic％'，值为0.55％......当我加载到包中时，它将赋值为0.0055.so我需要通过乘以100来更新...我怎样才能从包中获得实际值??????

解决方案

在您的工作流程中，您将需要使用Derived Column对象。在那里，您将选择excel列（百分比一），然后派生一个新列。这个列可以有一个表达式，你可以在那里进行乘法！

列名'traffic％'数据类型双精度浮点....

i在派生列中写表达式为（[traffic％] == [traffic％] * 100）

我的表列的数据类型为'numaric'

它将所有值都表示为'-1.000000000'

Hi,i am reading data from excel sheet to sql table.i had a column name as 'traffic%'in sheet and values like 0.55%... when i load into the package it will give value as 0.0055.so i need to update it by multiplying by 100...how can i get the actual value from the package??????

解决方案

In your workflow you will need to use the Derived Column object. In there you would select the excel column (the percentage one) and then "derive" a new column. This column can have an expression in it and you can do your multiplication there!

column name 'traffic%' datatype double-precision float....
i write expression in derived column as([traffic%]==[traffic%]*100)
my table column has datatype as 'numaric'
it gives all values as '-1.000000000'

这篇关于如何从excel加载％值到ssis包中的sql表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！