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

Hello John,

Thanks. I couldn't find an example this afternoon, but I'll try again
tomorrow.

Ron


Thursday, September 9, 2004, 6:23:07 PM, you wrote:

JMLC> Hello Ron,

JMLC> new to sql server so happy to be corrected

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

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

JMLC> hope this helps 

JMLC> john

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


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

JMLC> Thanks,

JMLC> Ron