• Try the following:

    create a variable of type string. Let's call it str_ExecSP.

    Populate this variable with the following expression:

    "EXEC dbo.proc_TEmptest " + (DT_WSTR,50) @[User::value1] + " , " + (DT_WSTR,50) @[User::value2]

    Then use this variable in an Execute SQL Task. As SQLSourceType, select variable.

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