derived column --replace " with space expression error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » derived column --replace " with space...

derived column --replace " with space expression error

Rate Topic

Display Mode

Topic Options

Author

Message

tabrez.test

Posted Thursday, May 20, 2010 9:02 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, March 17, 2011 8:06 AM
Points: 31, Visits: 123

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 ??

Post #925210

divyanth

Posted Thursday, May 20, 2010 10:20 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 8:38 AM
Points: 215, Visits: 550

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

Post #925338

« Prev Topic | Next Topic »

Permissions