Thank you very much, it's a surprising problem for me.

:satisfied:

I think you can use the Script Task component.

At first you must define a variable @x

After that you can set it in the Script Task component.

Dts.Variables("x").Value= "D:\Tempfolder\Report_on_" + @startdatevalue

as a...

Infact, I didin't understand why you wrote like that code.

Where is the difference from below code.

I think It's very easy.

SELECT * FROM t1 WHERE y IN (

SELECT y FROM t1

GROUP...