sql server 2008 r2 - Returning Output Paramters or Variables From SSIS Script Task / Script Component -

is possible return output parameters ssis "script task" has been called stored procedure using xp_cmdshell?

all samples have found far show how assign values dts package variables etc; , show them via message box every single sample see shows script task returning dts.taskresult = (int)scriptresults.success; or dts.taskresult = (int)scriptresults.failure ...

basically, have script task gets several values dll call works anticipated; values verified message boxes; have not been able ferret out how return stored procedure executed ssis package.

am missing obvious? please provide functional code example & or screen shots of control flow / data flow, etc., of how end end... e.g.: stored procedure -> execute *.dtsx package, passing parameters, including output parameters; , how same stored procedure can read output parameters in type of call; when results returned...

thanks in advance.

i don't know if possible return values in script task calling stored procedure, here's alternative way , may end result. create local ssis variables can capture values in script task being shown in message boxes. example create 1 called myssisvariable:

on script screen of task make sure select myssisvariable readwritevariables:

now in script task assign ssis variable whatever outputting message boxes:dts.variables["user::myssisvariable"].value = returnedvalue; ssis has value stored in variable can use when calling new stored procedure, have done whatever calling stored procedure supposed these variables, in execute sql task(for more 1 parameter keep adding ? such usp_mynewstoredprocedure ?, ?, ?:

making sure assign ssis user variable input parameter(in example used ole db, link shows how can accomplished using others):