sql - Adding multiple evaluation expression in For Loop SSIS -
is possible add multiple evaluation expression in loop container.
background: have file, in file value of field y/n, if value n have keep reading file until value y exit loop.
to this, used loop inside loop loading data record set destination , assigning values variable called "@value" in loop keeping condition
init : @start = 0 eval : @value = "n" assi : @start = @start + 1
now have add 1 more condition in loop such that, has iterate 5 times exit. used @value == "n" || @start > 10 in evaluation expression. not working. or part not considering, how can achieve it.
Comments
Post a Comment