CODEWITHSUNDEEP
ssisssis-data-types
Neo
Neo

Reputation: 16219

data type conversion into SSIS?

I have created one SSIS package from flat file I'm getting one price value.

But in derived table I'm converting the values into (DT_DECIMAL) as I need to insert it into database.

My problem is value 12345.6754. I want to take only 2 digits after the decimal, i.e., I want 12345.67.

For that I tried (DT_DECIMAL,2)MYCOLUMN and (DT_NUMERIC,10,2) MYCOLUMN too, but then also it is giving me 12345.6754 :(

please help

Upvotes: 0

Views: 287

Answers (1)

billinkc
billinkc

Reputation: 61211

In a Derived Column Transformation I'd look at using an appropriate String Functions and Other Functions (SSIS Expression) to manipulate the value. In this case, it sounds like you want toRound

Upvotes: 1

Related Questions