Post reply

Assign variable in derived column

  • January 17, 2013 at 2:55 am

    #267116

    Is it possible or any other way to assign the Derived column expression value in a column.

    for eg:

    @[User::newcol]= FILE_PATH + "/" + FILE_NAME.

    Please see the attachment for the same requirement. If this way is not possible then suggest me any other way to hold the expression value in a variable.

  • January 17, 2013 at 7:55 am

    #1578319

    sumit.joshij (1/17/2013)

    Is it possible or any other way to assign the Derived column expression value in a column.

    for eg:

    @[User::newcol]= FILE_PATH + "/" + FILE_NAME.

    Please see the attachment for the same requirement. If this way is not possible then suggest me any other way to hold the expression value in a variable.

    You can do this in a script task. Create your new derived column and then next in a script task assign that new column to the variable. See: http://www.bidn.com/blogs/PatrickLeBlanc/ssis/1098/ssis-assign-a-value-to-variable-using-dataflow-script-task

    HTH,

    Rob

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

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