SQL – SSIS Get FileName from Multi-Flat-File Import

SUBSTRING(FileName,LEN(FileName) - FINDSTRING(REVERSE(FileName),"\\",1) + 2,LEN(RIGHT(FileName,FINDSTRING(REVERSE(FileName),"\\",1) - 1)))

• Recommend on Facebook
• share via Reddit
• Share with Stumblers
• Tweet about it