As the title says. I'm trying to set it up so that if this one step of my process fails, it goes to a step that pauses for a couple minutes, then goes back to a previous step. It doesn't like this at all, it refuses to run past the first step now. Are you not allowed to do this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DTS: not allowed to create a loop?
- Thread starter Jasen
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
No you can not create a loop. Setup the job that calls the DTS package to retry on failure after X minutes. It's on the advanced tab of the job step.
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
- Status
Similar threads
