I want to ask a basic dts question. In my dts, I transfer data from one database to another. If this transformation become successful then an sqltask is executed. I add "on success" to execute this sqltask. Also I add "on failure" to loop this transformation. I want if this transformation fails, do it again. (try until success)
When I add "on failure" to return the beginning of the dts, the dts does not execute. So what must I do to add a loop into the dts, so that I achieve success at the end of the dts run?