i specified 2 varibales at package level and used then in for each loop and excel source connection
SourceFileName-- specifies file name can't use wild card doesn't work
SourceFilePath--specifies folder address
how to reterive the full path (including file name) into a varibale? we need to go through the files in the folder how we can do it without script?
please elaborate if u can