hi
in my ssis i m having 2 variables called a & b
by using row_count transformation i count this 2 variables value like
a=9
b=12
in my target table i want to add this 2 values update into my table..
ie update <table_name> set <col_name>=(?)
if i use one variable in execute sql task it will work
but when i use update <table_name> set <col_name>=(?+?)ie(a+b)
then pass 2 variable in execute sql tesk it will not work
so how to do this in ssis