Convert integer & decimal values into decimal column

Question

Naresh y 146

HI

everyone

i have in my source column, data look like this.

my column length allows Decimal (10,7)

these are the sample results in my column

5528

2666

3333.16

4102.65

how do i load these values into my target column Decimal (10,7)

we need to convert this integer values with decimals like below ( for the first two records)

5528.00

2666.00

3333.16

4102.65

how to convert using ssis derived column expression ,please suggest

Accepted answer

0 additional answers

Answer 1

Yitzhak Khabinsky 26,586

You don't need to do anything.

INTEGER values like 5528 will automatically be converted into DECIMAL(10,7) upon insert into a table where column has DECIMAL(10,7) data type.

Naresh y 146 Reputation points

2023-08-31T12:34:17.08+00:00

INTEGER values like 5528 will automatically be converted into

but it is not working, Conversion failed because the data value overflowed the specified type.

is there any expression can we convert into those values into decimals, please suggest
Yitzhak Khabinsky 26,586 Reputation points

2023-08-31T14:09:07.69+00:00

@Naresh y,

The DECIMAL(10,7) column data type precision is too high.

It is currently allow values as follows: 123.1234567

Just change it as DECIMAL(10,2).

So, it will allow values as 12345678.00
Naresh y 146 Reputation points

2023-08-31T15:55:28.5833333+00:00

Yes it will work for one of the column issue , i will verify the data and try fixing the rest of the columns , thank you for your support