SSIS Data type conversion

Hi All,

I am trying to convert a string datatype to decimal data type using a Data Conversion Transformation.

My input is 1200080

my desired output is 12000.80 But what i get is 1200080.00

How do i include last two chars in the string as decimal.

Thanks, Nk

asked Jul 19 '11 at 03:12 AM in Default

aRookieBIdev
2k ● 24 ● 40 ● 46

What code are you using to get this output?

Jul 19 '11 at 03:34 AM Mrs_Fatherjack

I am trying to get this done using expressions in DataConversionTransformation .

Jul 19 '11 at 03:57 AM aRookieBIdev

(comments are locked)

1 answer:

In my experience when I have needed to convert a value like 1200080 to 12000.80 I simply multiply by .01

answered Jul 19 '11 at 04:38 AM

Tim
31.5k ● 20 ● 31 ● 116

yes , thats how i have done it now.Was just curious to see if there is a proper way to type cast it.

Jul 19 '11 at 05:16 AM aRookieBIdev

I have yet to encounter one, every time I have tried converting to decimal with adding decimal places it just adds a period and however many zeros I specify to have decimal places.

Jul 19 '11 at 05:37 AM Tim

(comments are locked)

Your answer

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Topics:

ssis x751
data x41
datatypes x34
cast-convert x22

asked: Jul 19 '11 at 03:12 AM

Seen: 1322 times

Last Updated: Jul 19 '11 at 03:12 AM

SSIS Data type conversion

Follow this question

Related Questions