Ya i can do it .but the pro is what if there are many files on same name Ex : xxxxx_20111011,xxxxx_20111010,xxxxx_20111009

What file foreachloop takes??

And everyday file is having...

Can you please tell me about the file enumerator??

Thanks

Can you Please explain those two.

Thank You

actually am using it in expression of flat file connection manager to select file dynamically.

thanks

Thank for the reply..

am getting an error

TITLE: Expression Builder

------------------------------

Expression cannot be evaluated.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2008&ProdVer=9.0.30729.1&EvtSrc=Microsoft.DataTransformationServices.Controls.TaskUIFramework.TaskUIFrameworkSR&EvtID=FailToEvaluateExpression&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

Attempt to parse the expression ""C:\\ssis_training\\" +(DT_WSTR,4)DATEPART("yy",getdate())+

RIGHT("0"+(DT_WSTR,2)DATEPART("MM",getdate()),2)+

RIGHT("0"+(DT_WSTR,2)DATEPART("dd",getdate()),2)+" "+ % +"_06B.txt"" failed. The...