I have SSIS Package in which we uploads files and fetch date based on the file name.
The file name was ImportFile_XXX_20220501.
We used such expression (DT_STR,8,1252)SUBSTRING(FILE_NAME,FINDSTRING(FILE_NAME,"_",3) + 1,8) to receive int date.
Currently, the file name was changed to the ImportFile_UK_DumpXX_20220501.
Also, I have one variable in which I pass some specific parameter - FileCode. And I need to parse the new file name only when FileCode =1 .
Could you please help me to change the existing expression?