RIGHT( @[User::FullPath] , FINDSTRING(REVERSE( @[User::FullPath] ) , "\\", 1) - 1)
Here is what it does:
- Reverse the full path so the last backslash (\) becomes the first one.
- Get the position of the first backslash in the reversed string and this way we would know the length of the file name.
- Use the RIGHT() function get the file name since we know its length.