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 |
|
SergioM
Posting Yak Master
170 Posts |
 Posted - 2014-06-15 : 15:48:06
|
| I need to create an SSIS package that downloads many flat files & integrates them to my database. I never know when the distributor will update that file so I need to download them often. However if there is no update to that file I do not want to go through the resource intensive process of integrating these files.Using FileZilla I am able to see the last time the file was updated. Is it possible to have SSIS compare the timestamp of the current file to the previous one? Of course it would have to store the previous timestamp into some table, but I just want to know if this is doable or just a part of my imagination.-SergioI use Microsoft SQL 2008 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Get Timestamp from server before downloading?