in control flow I run "Execute SQL Task" to retrive array variables like State Code ('AR', 'WI', .. et). Then I run ForeEach Loop Container and pass global variable gv_StateCode into Data Flow, where I run stored proc with one parameter in "OLE DB Source" (like exec sp_StProcname ?) and i assign parameter in Set Query parameters dialog to gv_StateCode as Parameter0 = User::gv_StateCode.
When I run this package I got error: "The SQL command requires a parameter named "@p_StateCode", which is not found in the parameter mapping."
Please help me to resolve this issue.