title: Storing the return value from a function in a SSIS package variable
body: <p>I would like to use execute SQL step to  <code>select function_name()</code> that returns a value of data type <code>decimal(16,4)</code>  and store it in an SSIS variable and then use that variable and pass it as a parameter to a SP in the following step. However, when I am doing this and executing the steps, the output is always coming as 0, I am guessing the either the way I had set up my variables is bad or I am not passing it correctly, can someone please help!!!</p>