What i want:
Receive files from remote server every 8 hours daily,and if these files are all created during this period ,then execute next step
My thought:
I can receive files using FTP Task and i can set up job from Sql Agent
but how can i say whether these files are new or old?
Any idea? Thanks
or i can handle this like that
don't say whether files are new or not
only files exist then execute next step,and remove remote files and local files after finish executing
I think the key is how to deal with files status using FTP Task
how can i perform this task?
thanks in advance
I was just reading around and I found something that talks about knowing how old a file is...it may be interesting for you:
http://www.sqljunkies.com/WebLog/tpagel/archive/2005/08/05/16342.aspx
Rafael Salas
It's so cool,but you know
when i receive files from remote serve to my local,all files have same createtime and lastaccesstime
