What do you want the SQL task to do? Update the column?

If so the SQL needs to be

Update table_name

Set stage = REPLACE(Stage,'Closed Won','Awarded')

Mack