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
