Exiting a package without putting it on failure

[Nieve]

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...

[Nieve]

Just in case anyone wonders how can this be done- I had to add to my
scheduled job a step that calls another package (or an activeX) that verify
the existance of the file. If the package succeeds, I move on to the package
I originally wished to execute, otherwise I move to another step, a t-sql one
that does select 1 and ends the job on success.

Hope this will serve someone in the future... :p

Post by Nieve
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...