如何防止在SSIS中四舍五入 [英] How to prevent rounding off in SSIS

问题描述

大家好，

我创建了一个SSIS包，其中有一个任务，我们将数据从oledb源传输到oledb目标.(2个不同的表).

源表中的列1的类型为小数(11,3).但是，当我运行此任务时，目标表中的相应列将被四舍五入.即值0.25被存储为0,1.5被存储为1等等.

请告诉我，防止在这里四舍五入.

预先感谢.

Hi all,

I have created an SSIS package in which there is a task which we transfer data from oledb source to oledb destination.(2 different tables).

The column 1 in source table is of type decimal(11,3). But when I run this task the corresponding column in destination table is getting rounded off. i.e. value 0.25 is stored as 0, 1.5 is stored as 1 etc.

Please tell me to prevent rounding off here.

Thanks in advance.

推荐答案

我使用了oledb目标的Advance编辑器并更改了输出参数类型.

I used Advance editor of the oledb destination and changes the output parameter type.

这篇关于如何防止在SSIS中四舍五入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！