Top SQL Server Tools

SSIS - Datatype for loading from flatfile to table

Asked 1/31/2012 5:07:09 AM by Matt

Hi All,

I'm trying to load a flat file column which has a numeric value like 199.45 ( with two decimal places...but If I choose the Decimal (18,2)

Data type I get only 199.00...what is the best datatype to use for such scenarios...as at the end of Load I will be summing the column..

Thanks,

Matt.

Answered 1/31/2012 4:24:33 PM by RAMESH

(0)

Hi Matt,

Use Varchar datatype

It is suitable for every datatype

Answered 2/3/2012 9:01:27 AM by Jeremy Kadlec

(0)

Matt,

Something does not sound right. Based on what you explained you should use a decimal or numeric data type.

Can you elaborate more on each of the places where you define the data type to see if we can narrow this down?

I am wondering if there is a data type mismatch somewhere.

Thank you,
Jeremy Kadlec

Answered 4/17/2012 7:14:14 AM by Prakash	(0)
May be you can use float data type ...it will work for sure....

Sponsor Information