derived column --replace " with space expression error

• tabrez.test

  SSC-Addicted

  Points: 429

  More actions

  May 20, 2010 at 9:02 am

  #147081

  Hi

  in my package i am getting data from txt file and loading in to table sqlserver 2005.

  there is one column as mentioned below in txt file

  Lname

  -------

  ASD

  ABCED

  ASFGTE

  K"C"ASDF ------------ replace " with space

  PLKJH

  now i want to replace the " with sapce

  so i have used drived column transformation and using the following expression

  Replace([Lname],"\"","")

  but its not working

  can any one help me with this ??

• divyanth

  SSCarpal Tunnel

  Points: 4303

  More actions

  May 20, 2010 at 10:20 am

  #1170298

  The syntax looks correct.. can you post the error?