• In that case I would change the script task to be a script source component in the data flow task. That way the output from the webservice would already be in the data flow and you can then just add a derived column task for the variable and finally put it in a destination table.

    James Phillips
    Sr. Consultant
    Pragmatic Works