Unanswered: problem with workflow in dts designer...looping?
what im trying to do is:
1) ftp a file from a server to a local directory,
2) check the file for its lastmodified date
3) depending on a constraint, perform a data import.
However, if the file is not modified, this means that the server thats supposed to ftp and update the file has’nt done its job yet, in this case i would like dts to wait a few minutes and then again go to step 1. I want this to repeat for a whole hour until the data has finally imported OR if it hasnt imported at the end of the hour it will send me an email saying it failed.
The closest I have come to this type of functionality in DTS designer is picture 1.
In picture 1 i am using the WAITFOR DELAY '000:02:00' to wait 5 seconds between every step. However To do this would require me to create about 30 iterations to span the whole hour! The activeX portion works fine its just learning the flow in dts designer that is giving me the problems.
It would be so much easier to do what I did in picture 2, but nothing runs.