SSIS Variables

  • in SSIS

    ( Left(@[User::YourFileName],3) == "AP_" ? 101 : ( Left(@[User::YourFileName],3) == "VD_" ? 102 : ( Left(@[User::YourFileName],3) == "BK_ " ? 103 : 000)))

    In the above Variable i want to change the value in Hundreds place i.e from 101,102,103 to 201 ,202, 203 depending upon some Project param

    lets say if project param is 1, the values assigned should be as 101,102,103

    if project param is 2, the values assigned should be as 201,202,203

    if project param is 3, the values assigned should be as 301,302,303 etc please Help

Viewing 0 posts

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