Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jrockfl
Posting Yak Master
223 Posts |
 Posted - 2005-01-13 : 09:26:55
|
| I have some DTS packages that fire at night. Sometimes a package will error out and I have to start it when I get to work.Is it possible to retry the DTS package until it succeeds? |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-01-13 : 09:33:35
|
| Presumably you could use the 'on failure' workflow to loop back to itself (possibly via a delay mechanism). Not sure it's wise to do this though, perhaps someone has a better suggestionsteveAnd how is education supposed to make me feel smarter? Besides, every time I learn something new, it pushes some old stuff out of my brain. |
 |
|
|
|
|
|
Execute DTS Package, if it fails....then try again