There is a really good tutorial page here ->

As have been said above

1. check there is a result from the SQL

2. check the result set is set to single row.

3. on the reult set tab check the variable name is correct and that the result name is set to 0

4. Then its down to the variable type

hope this helps you.

Ells