team,

I have tried with below code in "Execute SQL Task"

Declare @FileDate datetime

declare @filename varchar

-- filename = test_source_file_20150920

Set @FileDate = substring(@filename,11,8)

select @FileDate

but it's giving default value not from file...

Hi Jeff,

It's working in SQL but not suits in ssis.

thanks,

Yes, one of your answer is what am looking for. Thank you.

🙂

Thank you, Let me try.