Post reply

User variable in Data Component Inflow task

  • November 5, 2008 at 7:34 am

    #124194

    Hi,

    I have a script task that creates a SELECT statement which it assigns to a user variable called var_SQL and wish to assign this value to the

    sqlCommand value under Custom Properties.

    So far I've user User::var_SQL and @[User::var_SQL] and beleive this only accepts a literal value and maybe I have to create a custom component.

    Can a user variable be used here or will I have to create a custom component?

    Any help welcome.

    EamonSQL

  • November 5, 2008 at 8:49 am

    #894309

    found this out myself...

    right click in the space within the data flow task and add the variable name to the expessions section of the properties.

    was easy enough in the end.

    E

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

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