How to Fail a Package

[dhoward007]

I need to be able to fail a package if my query doesn't return the correct number of records.

Is there a way to fail a dts package if a certain criteria is not met?

 

[MAK9974]

Raiseerror will fail your package

if (select count(*) from sysobjects)>50
begin
RAISERROR (50001, 16, 1,'Error')
end

 

[dhoward007]

Thanks I just figured that out.