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 |
|
tima
Starting Member
1 Post |
 Posted - 2005-08-15 : 10:43:01
|
| Hello,We have several DTS packages with some initial data reformatting steps that take quite a while. Sometimes steps toward the of the package fail for various reasons. Is there a way to configure a step to be skipped, or automatically marked as successfull? This would save us alot of time when this happens--Tim |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-08-16 : 03:37:48
|
| You could perhaps build the logic into your package, e.g. have a table somewhere that tells you what steps have been completed and use that to determine whether to execute a stepsteveAlright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer. |
 |
|
|
thebruins
Starting Member
31 Posts |
Posted - 2005-08-16 : 14:43:00
|
| or you could break a DTS package into smaller packages, create a job and define what should be done when the previous step (executing a package) fails |
|
|
|
|
|
|
Skipping Step in a DTS