• tejalchaudhari89 (4/4/2016)


    Thanks for your help.

    #1 is something I would like to use. But I have one additional requirement to the solution proposed in it. I need to get value of OUTPUT parameter returned by store procedure and save it in an SSIS package variable. I am stuck at how to fetch this OUTPUT parameter

    #2, this is what my package currently implements. But this solution is failing for larger number of records. I need to find an alternate solution

    Okay, if your output is too big for the SSIS buffer then it will cause an out of memory error. Can you not store the output in a temporary table and reference that in your Control/Data flow?


    I'm on LinkedIn