Put your code in a stored proc, and call the stored proc from the
Execute SQL Task. In the stored proc, check for your error condition(s)
and do an explicit RAISERROR statement on an error. This should be
recognized by the calling function (the Execute SQL Task), and should
produce a failure result for the step.
I think...
Martin Sloan
Empathica Inc.
2121 Argentia Road, Suite 200
Mississauga ON L5N 2X4
Tel 905.542.9001 ex. 219
Fax 905.542.8170
www.empathica.com
This communication is confidential and may be legally privileged. If you
are not the intended recipient, (i) please do not read or disclose to
others, (ii) please notify the sender by reply mail, and (iii) please
delete this communication from your system. Failure to follow this
process may be unlawful. Thank you for your cooperation.
-----Original Message-----
From: Tim Widdup
[mailto:mssqldba-ezmlmshield-x63692053.[Email address protected]
Sent: Wednesday, May 30, 2007 4:03 AM
To: LazyDBA Discussion
Subject: DTS success/failure flow
Anyone know if there is a way to return a failure from a 'Execute SQL
Task' in a DTS package. So basically return a 'DTSTaskExecResult_FAIL'
from the SQL task as you can from an ActiveX script task.
Thanks
(c) 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