• 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