S'been a whle since I used DTS, and I'm not on a 2000 SQL Server right now,
but if I remember correctly you should be able to set up a Package Variable
which is accessable from within the DTS SQL Task object. It'll most likely
be in the properties which you access via a right click both within the
"whitespace/background" of the "Parent" itself and by right clicking the SQL
Task object.
Each one is specific to either the "Parent" or the SQL Task object,
obviously......
Your "If" statement can set the value to be "0" or "1" or "-1" or whatever
you wish to signify success as a part of it's process.
A bit foggy, and again I apologise, but it should set you in the right
direction..... hopefully...
Thanks,
Jeremy Greaves
Fenris Software Consulting, Inc
>From: "Tim Widdup "
><mssqldba-ezmlmshield-x46105044.[Email address protected]
>To: "LazyDBA Discussion" <[Email address protected]
>Subject: DTS 'Execute SQL Task' control flow
>Date: Wed, 30 May 2007 09:49:11 +0100
>
>Let me rephrase the question - is there a way to control whether an
>'Execute SQL Task' in a DTS package can return a task success or failure
>depending on, say for instance, an IF statement in the SQL Task? Like
>an ActiveX script can return a 'DTSTaskExecResult_FAIL'.
>
>Thanks
>
>
>
>
>© Message Copyright EMX Company Limited 2007. All rights reserved.
>Full email disclaimer can be viewed at:
>http://www.emxco.com/disclaimer.html
>EMX Company Limited.
>Tel: +44 1279 858300, Fax: +44 1279 858301, Client Services Tel: +44 1279
>858333, Website: www.emxco.com
>
>Calls, e-mails and written correspondence may be monitored to assist with
>training, policy enforcement and resolution of disputes.
>____________________________________________________________________
>This email has been scanned for all viruses by MessageLabs.
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
MS Sql Server LazyDBA home page