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 |
|
luzippu
Starting Member
23 Posts |
 Posted - 2006-10-03 : 05:13:45
|
| hi everyone,I need to create a ssis in MS SQL Server 2005 that can complete the following:copy filea.mdb and fileb.mdb (readonly files) from s:\folder1\ to c:\folder1\ on a daily basis (let's say at 07:00am)only when the files dates (modified date) are greater than the equivalent files dates already in the destination folder. (there will always be an older version of the files in the destination folder)if at 07:00am there aren't any newer files, the copy does not run and somehow i get a confirmation message (netsend, email or log file)That's all!Currently i'm using a command file that just copies, but doesn't check the file dates.I've also tried the 'File Watcher Task' SSIS Control Flow Item, but it failed to work because the .mdb files are set as readonly.Thanks for your help. |
|
|
|
|
|
SSIS: copy files only when modified