I just want to give you update. I really appreciate your help. It works fine. I tried on my office database its works. Thanks for your time. Problem Solved.

Thanks all of you guys, I just want to give you update, i got the expression may be some one wanna to here it is, In derived column you can...

SELECT

[Date],

LTRIM(SUBSTRING([Date], CHARINDEX(',', [Date]) + 1, DATALENGTH([Date]))) AS DateNoComma

FROM [DELETE]

WHERE

CHARINDEX(',', [Date]) > 0

I am getting nothing, Both column are blank.

Thanks for your prompt reply, Here is the error that i am getting after i try syntax that you advised,

Msg 4145, Level 15, State 1, Line 2

An expression of...

Thanks for prompt reply, I am using SQL Server 2008. I am sorry i don't understand which code? I am using SSIS and this expression in derived column transformation. Thanks.

Is there any way i can run sql command to delete "Quotations"?

Source data look like this

AB

AC

AD

I am using

Source = Flat file source

Transformation = Data Conversion

Target = OLE DB

and i am getting this result (After i use...

Thanks for your reply,

1) After i ignore error its work fine but the result come out like this i.e

"AB"

"GH"

"AD"

Note:- Why "" in my result?

2) What you think there is...

Just Heads up I am getting this error if i use any field.

"[Flat File Source [14]] Error: The "output column ""COMP_TYPE"" (257)" failed because truncation occurred, and the truncation...

UPDATE TABLE B

SET TABLE B. L_RID = TABLE A. RID

INNER JOIN TABLE A

ON TABLE A. ID = TABLE B.ID

I want if Table A.ID Match with Table B.ID Update Table B....

I am using update syntax

UPDATE TABLE B

SET TABLE B. L_RID = TABLE A. RID

INNER JOIN TABLE A

ON TABLE A. ID = TABLE A.ID

Thanks for prompt reply. You are 200% right. I need help in expression):.