I have a ForEach File Loop where I'm assigning the full path of a file to variable @sSourceFile. Good to go.
Question: Using either VB.NET script or a Derived Column expression, how do you get the file name?
Example: @SourceFile = "H:\go\here\then\go\there\foo.txt"
Desired value: foo.txt