Re: Skip DTS steps

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 11/17/04 

Date: Wed, 17 Nov 2004 19:24:23 -0000

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@isslimREMOVE_TO_REPLYited.co.uk> wrote in message news:epzcz5MzEHA.1264@TK2MSFTNGP10.phx.gbl...
> 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
>
>

Relevant Pages

  • Here is the traceback from latex,
    ... Here is the traceback from latex, ... Package scrlfile, 2006/03/28 v2.95 KOMA-Script package ... hyperref 2006/09/06 v6.75e Hypertext links for LaTeX ... I've just inserted will cause me to report a runaway ...
    (comp.text.tex)
  • Re: Frontend backend problem
    ... > how to do this in the packaged product or when I package the product. ... a report. ... > it runs fine on pc with access install. ... > enter info in unbound form but when I press the command button to call up ...
    (microsoft.public.access.developers.toolkitode)
  • Re: Frontend backend problem
    ... 'Beginning Access 97 VBA Programming', by Robert Smith and David Sussman, ... >>> how to do this in the packaged product or when I package the product. ... a report. ... >>> it runs fine on pc with access install. ...
    (microsoft.public.access.developers.toolkitode)
  • Re: Tried Solutions from Post - Problem Error 2501 still exists
    ... On Error GoTo Err_CommandReport ... 'here is a typical NoData event I have in the report. ... Private Sub Report_NoData ... its NO Data event sending a MsgBox and cancelling the report. ...
    (comp.databases.ms-access)
  • Re: Where does SMS look for software installs to report?
    ... am still interested in knowing where SMS looks to report back a package was ... I was told by the package creator that I have to check the audit ... successful install, when it wasn't?" ... report states that the package will not run because the prior install was ...
    (microsoft.public.sms.misc)