Reading Excel worksheets

I have a DataFlow that reads data from an Excel file with different worksheets. If I read worksheets by names all ok.
If I read worksheets by progressive numbers all ok, but if the progressive number is in a variable, DI assume the variable is always 0 even if I initialize (or change in a loop) the value of the variable.
The variable ($NSHEET) is declared int and global to the job. See the image.

Can you help me, please?

DI XI, 12.2

:hb:
Reading Excel worksheet.jpg


mbiagini :it: (BOB member since 2009-07-06)