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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2009-02-03 : 06:05:26
|
| Hi i have files that come into a dir each day but i want to move these file out into a new folder. Can this be done in ssis by using the datetime stamp of the files. I don't want to use th name as i want to keeps files in the folder between certain dates. so if ths file was >= getdate() - 1 then move it to a different folder.any ideas ? |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-02-03 : 08:13:20
|
| A file system task in SSIS could accomplish this. Powershell can also do this.Mike"oh, that monkey is going to pay" |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-03 : 09:53:49
|
| you can also access created date of file by creating file system object in script task. then store it variable and use it to check. |
|
|
|
|
|
|
Moving file by there date time stamp