Execute SQL Task Error: no result rowset associated...

I am getting the following error when I execute my sql task:
 An error occurred while assigning a value to variable "NullVar":  " NO result rowset is associated with the execution of this query. "

I am executing a SP that has one input & one output parameter.  The output parameter is returning a single row for debugging if the sp failes.

I tried using Jamie's method:(http://blogs.conchango.com/jamiethomson/archive/2005/12/09/2480.aspx) to get it to work but keep getting the above error.  I have the following variables:
sqlSource (string) := Exec RBCprcsInsertWmsInvTransactionRecords '" + (DT_WSTR,10 ) @[User::SnapShotDate] + "', NULL"
NullVar (string)

In the execute sql task, I set the ResultSet to single row.  I set SQLSourceType = variable & sourcevariable = user::SqlSource.  In the result tab, I added a result set, NewResultName with the variable user::NullVar.  I tried different configurations with the parameter mappings but nothing seemed to work.  I didn't know if i still had to use this if I am using the sqlSource variable to drive the task.
So I am not sure what I am missing here.  Anyone have any suggestions?
Thanks!
JohnStart Free Trial