hi .. I am using T-Sql task for executing a stored procedure.. this procedure jst returns one value back to me. i could not found a way to achive this.. please help me. its very urgent..... thanks in advance

Set the return type to Single Row. Now you will be able to access the Result Set tab. Pass the variable that will hold the returned value into here (assuming OLEDB) map it as Paramter 0 Hope this helps. Let us know how you get on.Peter Carter-Greenan http://sqlserverdownanddirty.blogspot.com/

If your stored procedure returns this value as an OUTPUT parameter, using the Return Type of SingleRow will not work for you. You need to use output parameters on the Execute SQL Task. Talk to me now on