[dba-SQLServer] Fail a DTS Step Based on Query Result?

Hello Ron,

new to sql server so happy to be corrected

but I would use	the workflow properties and an active x script.

1)Add Active x Script task 
2)Right Click on icon, select workflow - workflow properties
3)Select Options tab
4)Click Use ActiveXscript
5)Click propeties
6)Write script to check query result and determine success failure
Afraid I can't send script as mail sweeper here blocks it
However BOL, under using active X script in DTS gives an example which you
could adapt.

hope this helps 

john

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of
chizotz at mchsi.com
Sent: 09 September 2004 23:05
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Fail a DTS Step Based on Query Result?


Is it possible to fail a step in a DTS package delibertaely, based on a
value 
returned from a query? I would like to branch differently depending on the 
results of a SQL task, but the only options are on completion, on success,
or 
on failure. I don't see a way to do this, but it sure would be convenient.

Thanks,

Ron

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


The contents of this email and any attachments are sent for the personal attention
of the addressee(s) only and may be confidential.  If you are not the intended
addressee, any use, disclosure or copying of this email and any attachments is
unauthorised - please notify the sender by return and delete the message.  Any
representations or commitments expressed in this email are subject to contract. 
 
ntl Group Limited