sql - How to use the date from a FileName and use this date in an expression - SSIS Package -

i quite beginner ssis packages bear me. trying do:

i have daily files in format of yyyy-mm-dd_filename_bla_bla.tsv date of file need added in table trying import it. doing manually derived coloumn expression: (dt_date)(dt_dbdate)"yyyy-mm-dd"

is there possibility automatically take file name , take date part import table.

the things find on internet getting date file name, opposite.

i hope provided enough information, , can me out problem.

thanks in advance.

if know file name keep file name in variable example let file name : 01/02/2015_kjh.bgd

then using derived column use string functions left(@variable,10)

10-> length of date

then map oledb destination