how to convert varchar to integer in ssis
I have a source table with coulmn name phone_no with datatype as varchar(15). In destination table the datatype equivalent to this column is integer. for example if i have phone_no as 919009998886662 ,then what type of conversion I need to use so as to match with the target data type I tried to execute but I got this kind of error "Invalid character value for cast specification". "Conversion failed because the data value overflowed the specified type." please help me on thisfuzailrashid
November 16th, 2010 12:49am

this value can not be Integer, It is much bigger than int but you can convert it to decimal with a data conversion transformation or with derived column transformation with this expression : (DT_DECIMAL,0 )InputColumnhttp://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
November 16th, 2010 1:27am

You have to change the datatype in the destination table to either Varchar(and directly insert the values without doing any conversion inside SSIS) or Decimal (if you are following the Reza'a suggestion).Nitesh Rai- Please mark the post as answered if it answers your question
November 16th, 2010 2:21am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics