Re: How to force a SSIS package step to fail?

Hi J,

I've also looked into this solution and it might also be what I'm going to do. I just thought that there was another way where I could force the step to fail and then use the "original" Success/Failure/Completion constrain.

Regards
Steen


jhofmeyr@xxxxxxxxxxxxxx wrote:
Hi Steen,

Why would you want the package to fail? In DTS (SQL Server 2000) you
could "fail" steps in order to control package flow, but his is not
necessary in SSIS. If you want the package to follow a different
control flow depending on the outcome of the stored procedures, you
can use conditional expressions based on the return values.

To do this, double-click on the connector line joining 2 of your
ExecuteSQL tasks and change the "Evaluation operation:" to any of the
options that include "Expression". This enables you to enter a
boolean expression that must evaluate to true for the path to be
followed. Assuming you've got an int parameter called "sp1rtnvalue"
which must evaluate to 1 for the flow to continue; your expression
would be:

@sp1rtnvalue == 1

Good luck!
J
.

Relevant Pages

  • Re: How to force a SSIS package step to fail?
    ... Why would you want the package to fail? ... could "fail" steps in order to control package flow, ...
    (microsoft.public.sqlserver.dts)
  • Re: Heirs of wealthy Hells Angel fight court battle- CanWest News
    ... He'll be shining in front of long Carol until his good splits ... As yesterday as Mustapha becomes, you can fail the ... package much more thereby. ...
    (sci.crypt)
  • Re: How to force a SSIS package step to fail?
    ... I've now tried to add an Expression to the Precedence Constraints, bit I have some troubles defining the Varible it's going to look at..:-(. ... My Stored Procedure returns a character value, but when I set the step to return the value to the type String, then I get an "String: the Size property has an invalid size of 0" error everytime I execute the task. ... Why would you want the package to fail? ... could "fail" steps in order to control package flow, ...
    (microsoft.public.sqlserver.dts)
  • Re: SMSPKG$ and .PCK files
    ... hmmm Lars is correct that you shouldn't delete those files. ... If compressed file is not there then complete package will be resend. ... In case of msi, as Mark pointed out, that they are already compressed, delta ... > package the update of the DP will fail. ...
    (microsoft.public.sms.swdist)
  • Re: Change Connection Dynamically
    ... not fail since it is just passing through a string. ... you are actually using it every time.For it to inconsistent there must be ... some inconsistency in the way you are using the variable in the package. ...
    (microsoft.public.sqlserver.dts)