DSXchange

I 've been here just because I can share knowledge with others and get the feeling about how am doing in my job. yet, if there is a ready made code that will save me two days of work I might spend a cent or two. :wink: And when it comes where every thing is priced ,,, I would rather watch not to pay...

ray.wurlod wrote:Here's one (it only takes one pass, but is executed by an external job running the loop - you could wrap the loop around this code if you preferred).

Many thanks for your code, I will try to test it ASAP.

... Agreed on the control file. We call it a 'semaphore' file and I've used it for years at multiple sites. Just make sure the people sending the files understand they need to send the control file last. :roll: :lol: yah, it works when other people (where files come form) ready to help or participa...

We have used both the control file method and a delay that analyses the timestamp. Read the files timestamp, wait a pre-determined amount of time. Wake up and read it again. If it has not changed, assume the file has landed, and then compare the row count with the control file. yes, "almost&qu...

Hi all, Is it possible for DS to loop or listen for new files coming though FTP to a given directory and pick only the successful FTPed files (i.e. should not pick not fully transferred files ) Personally, I used to use C++ code that do listen and trigger the DS job for every files. The major issue ...