Exiting a package without putting it on failure
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Hello all,
I've been asked to write a package that looks for a file in a certain
directory- if the file is found, I need to treat it; if not I need to end the
package without it showing as a fialure when scheduling it as a job in the
SQL Server Agent.
In other words- is there a way to put an activeX task on failure (when I
don't find the file) without it passing the whole package to a 'failure'
state?
Hope this makes sense...
.
Relevant Pages
- Re: Monitor individual tasks within a DTS package
... failure, rather than using multiple Failure constraints. ... > Personally I find this too much hassle, but if you set package logging on to ...
(microsoft.public.sqlserver.dts) - Re: Monitor individual tasks within a DTS package
... > tasks that will redirect the package flow to the EMail task in the event ... > failure, rather than using multiple Failure constraints. ...
(microsoft.public.sqlserver.dts) - Re: catch replacing useful errorInfo
... I can agree on all that as good general advice. ... failure, I return a message to the client (actually the application ... If a buggy package is added to the system, ... Third example allows silent failure of a documentation proc. ...
(comp.lang.tcl) - Re: DTS package succeeds, but log indicates failure
... Task failure does not mean package failure. ... "Fail package on step failure" option can be set on ... the log file it says that the pacakge as a whole has failed, ...
(microsoft.public.sqlserver.dts) - Re: Run Task at the End of the Package?
... naturally - I might suggest you wrap it using a STEP 2 from a SQL_JOB ... that executes the package; in that case you can signal that on JOB STEP ... On failure, you have to do something or quit. ... This is for SQL 2000 DTS. ...
(microsoft.public.sqlserver.dts) |
|
