SSIS variables from dataflow to control flow

  • Hellow, How to pass the values of variables from dala flow to control flow. I have a variable delcared at the package level. I set the value to the variable from the tables in data flow and tried to access the variable in the control flow, but the value is blank. I thought the package level variables should be avaialble within the package. could anypne help me on this plaese?.

  • Your assumption is correct, so something else must be happening.

    a) Double check the scope of the variables

    b) Double check that the variable is actually being set as you think (Msgbox in script, or maybe via derived column / data viewer.

    Phil

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • Phil, I put a messagebox in script component in dataflow, and the values is set, but for some reason its lost once it come of that dataflow. I checked the variable scope andit's at the package level. I don't know why it's not available in control flow.

  • 🙂 I'm sorry, but I'm out of ideas. This is simple and there's not much else to check.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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