you need to do two things:

1) Modify your query as Select Top 1 contactname as GetName from contacts where contactname like 's%'

2)Change the 'ResultSet' property of your execute SQL task to Single row

Now go to the result set tab of your execute SQL task and map your query result to the user variable.

This should work.

Thanks

Pankaj