How to convert INTEGER Value to STRING

Question

Post reply

How to convert INTEGER Value to STRING

smsreddy

SSC Enthusiast

Points: 100
More actions
October 29, 2008 at 1:00 pm

#200616

Hi Can some one share the function to convert from STR to INT in SSIS tool

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

z\xcssswwww Valued Member Points: 51 More actions · Answer 1

Just use I2 data type for the int column in the mapping step

samtel143 Old Hand Points: 325 More actions · Answer 2

samtel143

Old Hand

Points: 325

November 17, 2008 at 9:22 pm

#899668

use DATA CONVERSION tool in the dataflow task

sameer.mirza SSC-Addicted Points: 426 More actions · Answer 3

ryes data conversion transformation works most of the time. But in some cases it gives you the error message related to the potential data loss. I think the best way is to go with the derived column transformation.

Does any one know the expression to convert the string data type to int.

elegantkvc SSCommitted Points: 1910 More actions · Answer 4

hi,

You can use the DT_Numeric to convert the string to integer.

Thanks

vijayalaya cholan

elegantkvc SSCommitted Points: 1910 More actions · Answer 5

You can also use the ( DT_I2)[String Name] to convert the string to integer.

Thanks

Vijayalayan cholan.K