Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MichelleMabbs
Starting Member
24 Posts |
 Posted - 2014-03-28 : 07:54:04
|
| Hi there i have a package set up that moves xml files into an archive directorythe files look like the followingXXX_27_03_2014_Area_54XXX_27_03_2014_Area_52XXX_27_03_2014_Area_53XXX_26_03_2014_Area_54XXX_26_03_2014_Area_53XXX_26_03_2014_Area_52i can get all the files transfered over using a foreachloop & file system taskNow i want to return the files that matches yesterdays date onlyI know that i need a varibale to return only the files with the correct date in, however i cant seem to work it outany help will be gratefully recievd :)Michelle |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Return files with dd_mm_yyyy