I have a Foreach Loop Container and I'm using a variable to pick-up and process all xlsx files in a directory. It only works if I specify the full path and exact file name in the value of the variable.
I am using an excel connection manager in the package.
Is there a trick to making it pick up any xlsx files? I have the correct directory and filespec in the Foreach Loop properties, but again, it will only run the file I specifically point to in the Value of the expression.
Any help you can offer would be greatly appreciated, thank you.