Home > Archive > MS SQL Server DTS > March 2006 > Continue DTS based on results of a Stored Procedure Calls output.









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Continue DTS based on results of a Stored Procedure Calls output.
Fab

2006-03-23, 1:31 pm

I have a stored procedure that returns either a pass or fail.

I want to call the stored procedure inside of a DTS. This DTS has many 4
steps. between step 3 and 4 I want to add a check which will call the stored
procedure and continue if it returns a "Pass" and Fail if it return
"Fail"....

Thx



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com