SSIS: How to prevent rounding off

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » SSIS: How to prevent rounding off

SSIS: How to prevent rounding off

Rate Topic

Display Mode

Topic Options

Author

Message

webblazing

Posted Wednesday, October 10, 2012 9:49 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, October 11, 2012 4:04 AM
Points: 1, Visits: 4

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.

Post #1371195

Vikash Kumar Singh

Posted Thursday, October 11, 2012 4:51 AM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 7:03 PM
Points: 60, Visits: 142

Can you check the Input and Output Properties OLEDB Source and confirm the OLE DB Source Output->Output Columns, what data type is appearing into it? It shoulde be a DT_DECIMAL OR DT_NUMERIC with Precision as 11 and Scale as 3?

Thanks,

Vikash Kumar Singh || www.singhvikash.in

Post #1371350

« Prev Topic | Next Topic »

Permissions