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.

MS Sql Server LazyDBA home page