Apologies in advance, I can see that there are so many similar questions posted on this in the past, but for the life of me, I can't get what should be a very simple solution working.
Essentially I'd like to:
Run a job that requests for a parameter for search criteria of a filename, i.e. Companies, Users
Run a transformation to create a correctly formatted wildcard and populate into a variable
use the variable to run a transformation to get filenames based on the previously created wildcard
It seems simple in theory, but for some reason the final step that looks for the filenames just can't seem to get access to that variable.
Any help would be most appreciated,