Hello.
I’m not really sure about the message type of your sent message going to SQL. Did you use the Add Generated Item to generate the schema? Are you getting any errors? You do need the request-response send port in order to get a response back from the SQL Adapter.
Another way to do this is to simply use a helper .net component to take the property and make a direct database call (using something like Enterprise Library for data access). This would be a better preferment solution (since you by pass the message box) and would be my approach for this type of task.
Hope this helps.