Convert from char to decimal/int

• paravia

  SSC Enthusiast

  Points: 130

  More actions

  April 30, 2008 at 3:58 am

  #71249

  Hi at all,

  i need to export a table where there is a

  column type char(10).

  I have to convert it in numeric(10) o int(10).

  in trasform windows of export there is

  DTSdestination("PIPPO")=DTSSource("PIPPO")

  I have to convert PIPPO from char(10) in decimal(10)

  In column PIPPO there is only numeric value

  and NULL/BLANKS value.

  In this case the procedure go in error about null/blank values.

  Can you help me ??

  Best regards Carlo

• Mahesh Bote

  SSCrazy Eights

  Points: 9107

  More actions

  April 30, 2008 at 4:46 am

  #808917

  [font="Verdana"]Carlo, can you tell us, what exactly error you are facing?

  Mahesh[/font]

  MH-09-AM-8694

• paravia

  SSC Enthusiast

  Points: 130

  More actions

  April 30, 2008 at 7:16 am

  #809019

  Istruction is :

  DTSDestination("PIPPO")=int(DTSSource("PIPPO"))

  Error is :

  Error Source=Run time Error ov Microsoft VBScript

  Erroe Description=Type non corrispond: [" "]

  Input = char(19) 10 blanks

  Output must be 0

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  April 30, 2008 at 4:16 pm

  #809364

  paravia , blank string value cannot be implicitly converted to numeric value.

  SELECT CONVERT(int, '')

  will return an error

  What those blanks do actually mean?

  NULL? Zero? Something else?

  In any case update your source table in order to containt the correct data.

  Enforce some constraint on the table to prevent wrong data from being inserted in it in future.

  _____________
  Code for TallyGenerator