Post reply

How to change the value of an user variable from within a data flow task

  • June 11, 2009 at 8:02 am

    #135095

    Is it possible to change the value of a user variable from within a data flow task please? I'm trying to change a package level variable's value within a data flow task. Should be easy I'd have thought but can't remember how!

  • June 13, 2009 at 1:01 pm

    #1009157

    Griffster (6/11/2009)

    Is it possible to change the value of a user variable from within a data flow task please? I'm trying to change a package level variable's value within a data flow task. Should be easy I'd have thought but can't remember how!

    Yes, it is possible. You have to use a script component, which has base class member VariableDispenser. You can LockForWrite -> Set -> Unlock the variable.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • June 15, 2009 at 3:27 am

    #1009516

    Ok, many thanks. Will try that out.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply