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 directory
the files look like the following
XXX_27_03_2014_Area_54
XXX_27_03_2014_Area_52
XXX_27_03_2014_Area_53
XXX_26_03_2014_Area_54
XXX_26_03_2014_Area_53
XXX_26_03_2014_Area_52
i can get all the files transfered over using a foreachloop & file system task
Now i want to return the files that matches yesterdays date only
I know that i need a varibale to return only the files with the correct date in, however i cant seem to work it out
any help will be gratefully recievd :)
Michelle |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Return files with dd_mm_yyyy