sql - Identifying Excel filepath in SSIS -

i'm using this foreach loop tutorial in attempt import excel files folder sql table via ssis. followed steps can't excel source block recognize variable filename. error shows filepath did not work @ all:

could not retrieve table information connection manager connectionmanagername 

the source file formatting, type, , folder consistent. has else had problem? suspect i'm missing between steps 2-4 in link, wouldn't know is.

i've solved it! used connectionstring in step 3b instead of excelfilename. reading answer, exact connectionstring format vary (see here) like

provider=microsoft.ace.oledb.12.0;data source=c:\myfolder\myexcel2007file.xlsx; extended properties="excel 12.0 xml;hdr=yes";