Hi @Ali Ahad ,
SSIS Expression function TOKEN() is very handy for such scenario.
Let's say User::fileName variable has value "CMDB_Transactions File January_yyyymmdd.xlsx"
TOKEN(@[User::fileName], "_", 2)
For the reference: token-ssis-expression