Post reply

Assigning TaskName of PrpertyExpressions of a data flow to a package variable

  • June 28, 2011 at 9:16 pm

    #240687

    Hi All,

    I want to assign the name of the current data flow thats is under execution to a package variable and use it.How can i perform this??

    Thanks,

    Sreelekha

  • June 29, 2011 at 12:57 am

    #1345672

    You need to create an Event Handler on the dataflow.

    The type of this event handler depends on what you want to do, but OnPostExecute or OnPreExecute seems a good choice.

    Inside this event handler, you create a variable with the scope set to this event handler. Set EvaluateAsExpression to true. Using an expression, you can set the value of this variable to System::TaskName, which will hold the name of the data flow.

    Beware, the scope of this variable is the event handler, not the package.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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