How to force a SSIS package step to fail?

Hi,

This might be simple, but I simply can't figure out how to do it.

I'm having a SSIS package that contains 10 "execute SQL Task" steps. Each of these steps runs a Stored procedure. Based on a value that is being returned by each of these Stored Proc's I'd like to be able to set the "outcome" of each step to either "Success" or "Failure" but I can't figure out how to do it...:-(.
I think I've been around many different options, but haven't found the way to do it. I've hoped that this could be done failry straight forward, but maybe I'm wrong?

Does any of you have any suggestions on how to acomplish this without having to make it overly complicated?

Regards
Steen Schlüter Persson
CRM System Specialist / DBA
.

Relevant Pages

  • Re: SP output to a text file using DTS
    ... If the number is above the threshold then I save the unique id, date of request and I create a filename and I insert this information into a table. ... I want to schedule DTS to read the unique id and filename from the table and generate a text file with the results from the stored procedure. ... I have an Execute SQL Task that executes the stored procedure but I need to pass the unique id and I need to output the results to a text file. ... helping me reach a working solution. ...
    (microsoft.public.sqlserver.dts)
  • Re: SSIS 2005 Execute SQL Task RAISERROR
    ... Warning: 0x80019002 at Execute SQL Task: The Execution method succeeded, but the number of errors raised reached the maximum allowed; resulting in failure. ... This occurs when the number of errors reaches the number specified in MaximumErrorCount. ... SSIS package "Package.dtsx" finished: Failure. ...
    (microsoft.public.sqlserver.dts)
  • RE: Passing Parameters to an Execute SQL Task in SSIS
    ... I create a stored procedure in Northwind: ... Then in SSIS development environment, double click the "Execute SQL Task", ... Data Type: LONG ... Charles Wang ...
    (microsoft.public.sqlserver.dts)
  • RE: Passing Parameters to an Execute SQL Task in SSIS
    ... I create a stored procedure in Northwind: ... Then in SSIS development environment, double click the "Execute SQL Task", ... Data Type: LONG ...
    (microsoft.public.sqlserver.dts)
  • Re: output
    ... Vyas, MVP (SQL Server) ... > The main problem i have is in Execute SQL Task, ... > that's why I asked if it should be done in Active X Script... ... I created a stored procedure that returns a value after execution ...
    (microsoft.public.sqlserver.dts)
Loading