Foreach Loop - not passing file name into my variable - unsure as to why this is

i using technet tutorial: 

how to: loop through excel files , tables using foreach loop container

it seems work great, except each file loop isn't picking actual file name of excel file , passing variable.

i have each file enumerator, points folder: "c:\current data processing" , files: "*.xls" retrieve qualified name.

in variable mappings created variable of type string scope name of ssis package , index in variable mappings 0.

(can explain index way, don't understand that.  variable mappings provide range of columns/indexs place stuff in?  how view see options are?  that's less pressing question)



now package runs fine, because points hard coded value entered variable.  if remove package fails run.

i don't understand why foreach loop container isn't putting name of excel file in c:\current data processing folder variable"excelfile"?

thanks!

hi,
as nitesh suggested put script task , put : msgbox(dts.variables("excelfile").value.tostring())
see if proper name being populated in variable.
if not need check variable mapping.

---

hope helps !!
sudeep   |    my blog

SQL Server  >  SQL Server Integration Services