I can not assign expression return in the SSIS variable

0

Task to enter Value in Variable by select result

MyintentionwiththislogicistopassacalculatedcolumnfromoneexcelfiletoanotherusingastageareawhereIjustwanttomodifyacolumninthedatabasetableandtheninsertitintotheexcelfile.SoIamusingvariabletogettheresultofselectanduseasvalueinupdate,becausethereismorethanoneconnection.ButthevalueofthevariabledoesnotchangewhenIrunthe

    
asked by anonymous 16.10.2018 / 17:11

1 answer

0

The variable you are using in the mapping is not the same as the variable you are leaving in the Result Set. Now, when you use a variable that is mapped, you do not need to put its name, just put in the query a question mark (?) That it will use the variables mapped based on the name of the mapping them (0,1,2 , 3).

    
18.10.2018 / 12:19