Hi

It is possible to make DTS skip a number of steps according to the result of
a query for example:

IF (SELECT *
FROM Modified_sage_tables
WHERE filenme = 'ACCESS1') IS NULL
GOTO "STEP XXXX"
ELSE
GOTO "STEP YYYY"



Where "STEP YYYY" and "STEP XXXX" would be the steps of the package that I
wanted it to skip to, I would then want it to continue running through the
remaining steps of the package.

One idea I had was to make it report an error with that step, then I could
have a success and a failure route out of that step guiding it on to the
appropriate step. However I can't seem to find anything to say how to get
it to report an error back. Thanks in advance.

Dan

Have you taken a look at this article

Skip the execution of an individual Task
(http://www.sqldts.com/default.aspx?214)

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"IT Dep" <it (AT) isslimREMOVE_TO_REPLYited (DOT) co.uk> wrote

Hi

Thanks for your resonse, that looks to be very helpful, unfortunately as so
often happens loads of things have landed on my desk and I haven't had the
opportunity to look into it fully. I will keep you posted. Thanks

Dan
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote