Thanks for sharing information on setting up sql job notification. Is there a way that sends the job failure message on email.

Can anybody suggest me how to use the replace function in derived column transformation.

I have a expression REPLACE(UPPER(NAME),@[User::Quote]," ") but this is not replacing quote in destination.