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

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Steen,

There is no concept of "Length" in a package string variable - it is
as long as you make it.
Try deleting and re-creating the ExecuteSQL task. Sometimes when you
change a stored proc the metadata in SSIS doesn't update correctly.
You might also consider changing your SP into a function if all it's
doing is returning a value...

I think using expressions is a better method of controling application
flow than Succ/Fail/Comp ... what happens if your task were to
actually fail?

Good luck!
J
.