Did you use the Add Generated Items to add the schema to call the stored procedure?
You might want to check the SQL white paper is you have questions: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/BTS_2004WP/html/90a5261b-a220-41bf-bf7f-fd759239242c.asp