Why first don't you move all the old files (which would be yesterdays' files) when the package starts? If this is not feasible and if you are producing many files, then you ought to detect the yesterday's file based on its modified date time stamp. You can use the Script Task inside the for each loop when you iterate over the old file to determine such and just to archive right there. Example: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/2d15c297-4d5c-4b63-9f91-6691ff9d1bf5/Arthur My Blog

Hii am dynamically creating flatfiles with name as 20111010 161912_xxxx.txt everyday the package creates a new file and i have to move the oldfile to archive. am using foreach loop and file sytem task for that. but the pro is what i have to specify in filesystem source connection??

Why first don't you move all the old files (which would be yesterdays' files) when the package starts? If this is not feasible and if you are producing many files, then you ought to detect the yesterday's file based on its modified date time stamp. You can use the Script Task inside the for each loop when you iterate over the old file to determine such and just to archive right there. Example: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/2d15c297-4d5c-4b63-9f91-6691ff9d1bf5/Arthur My Blog

Thanks for the reply. The Link is not Working

It did for me. I was able to shorten it into http://mcaf.ee/1k7ln Arthur My Blog