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 |
|
leedoolan
Starting Member
12 Posts |
 Posted - 2002-07-11 : 11:09:26
|
| how can I report a dts success in VB even though some steps may fail?Thanks |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-07-11 : 11:28:25
|
quote:
how can I report a dts success in VB even though some steps may fail?
You're mixing semantics so I'm not exactly sure what you're asking. To report the success of an ActiveX script task you return the appropriate success constant. To have the package run successfully even though certain steps may fail is a function of your precedence constraints ( on error, on completion, on success ) and whether you have marked a step as "fail package on task failure".Jonathan Boott, MCDBAEdited by - setbasedisthetruepath on 07/11/2002 11:28:50 |
 |
|
|
leedoolan
Starting Member
12 Posts |
Posted - 2002-07-12 : 07:04:54
|
| Thanks for your comments.So how would I go about doing this in an activex task.Also is the "fail package on task failure" box available on Server 7? It's just I can't seem to find it in the properties of various steps. |
|
|
|
|
|
|
report a dts success