Jim Horn
asked on
SSIS 2008R2 VB.NET Script: How to get the file name from a full path
Hi All
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
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\
Desired value: foo.txt
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.