Returning Output Paramters or Variables From SSIS Script Task / Script
Component
Is it possible to return output parameters from a SSIS "Script Task" that
has been called by a stored procedure using xp_cmdshell?
All the samples I have found so far show how to assign values to dts
package variables etc; and show them via a message box but every single
sample I see shows the script task only returning a Dts.TaskResult =
(int)ScriptResults.Success; or Dts.TaskResult = (int)ScriptResults.Failure
...
Basically, I have a script task that gets several values from a dll call
that works as anticipated; values are verified with message boxes; but I
have not been able to ferret out how to return those back to the stored
procedure that originally executed the SSIS package.
Am I missing something obvious? please provide a functional code example &
or screen shots of control flow / data flow, etc., of how to do this end
to end... E.G.: From a stored procedure -> Execute a *.dtsx package,
passing it parameters, including OUTPUT parameters; and how that same
stored procedure can read those output parameters in this type of call;
when the results are returned...
thanks in advance.
No comments:
Post a Comment