change the unformat data into format

• muralikrishna37

  Ten Centuries

  Points: 1233

  More actions

  December 18, 2008 at 8:39 am

  #125109

  Hi SSIS gurus,

  i have a problem.i have a flat file source, in that 7 columns are there. the final column is Balence,but in that Balence column my data is look like

  Balence

  -------

  25.67-

  -35.23

  56.12-

  -28.34

  56.9-

  -234.67

  123.67-

  my requirement is i have to load Balence column unformat data into format in sql server destination like

  Balence

  -------

  -25.67

  -35.23

  -56.12

  -28.34

  -56.9

  -234.67

  -123.67

  Tell me which transformation i have use to fix this problem.

  Thanks

  Murali

• Mukti

  SSCrazy

  Points: 2826

  More actions

  December 18, 2008 at 6:22 pm

  #914942

  You can use derived colum to format the balance colum in desired way

  RIGHT([Balance_Col],1) == "-" ? "-" + SUBSTRING([Balance_Col],1,LEN([Balance_Col]) - 1) : [Balance_Col]

  HTH

  ~Mukti