I've got a really irritating problem.
I've created a DTS package, well, actually 4, to import data into a number of tables, from a tex file...
the packages are run by a job that is scheduled. on success of the first step of my job, I need it to go to step 2, and on success of that yob, I want it to move on to step 3 (each step being another DTS packages).
my problem is this. inside these DTS packages, I check for certain things, if a check is true that task is successfull otherwise the task fails. I then have workflow arrows to to the next Task that needs to be run in each case. If the task failed I do something to rectify the problem and then do the check again, if the check then succeeds, the packages ends and I want the next step in the job to run.
BUT!!! because I had a task fail in the package, that package is then seen as having failed, even though the last step was succesfull.
how can I avoid this?
if the task fails and I handle that successfulle, by getting rid of what ever made it wail and I then check again and the check is successfull, I want the package and the step in the job to be successfull