More SSIS Help please using Output Parameters and Variables

I have an SSIS package that I am writing to replace a very long winded process which uses an access 97 (would you believe it) which also links to and updates DBF files and it's fair to say I'm struggling, the DBF files do have to stay and have to be output in the same format. The issue I'm facing at the moment is that I have an execute SQL Task that runs a stored procedure to basically checks the integrity of various tables, if any of the statements in the stored procedure come back with a value the SSIS package needs to stop and the user needs to manually check various things.

I've set the stored procedure with the output variables see below:

alter PROC SX_CheckLookup   @Output as varchar(500) Output, @Total as varchar(10) Output
as  
/*  
Stored procedure to check the contents of various tables.  If comes back with records then raiserror to stop SSIS and get user to check the details  
Created by:  Annette Allen  
Created on: March 2011  

  ** Test Script **
  Declare @Output as varchar(500)
Declare @Total as int 
  exec SX_CheckLookup @Output output, @Total output

*/  
declare @Outcome as varchar(500)  
declare @Count as int
declare @Total1 as int
--declare @Total as int

set @Count = (  
select Count(*)  
from (select distinct MULTI_CODE FROM VAMPEMP AS X WHERE NOT EXISTS  
(  
SELECT DRUGCODE FROM DRUGEMP WHERE DRUGCODE = X.MULTI_CODE) ) as x  
)  

 set @Total1 = isnull(@Total,0) + isnull(@Count,0)
set @Outcome= (  
select case when @Outcome is null and @Count > 0 then 'Multicode'   
when @Outcome is null and @Count = 0 then 'No records'  
else @Outcome + '; Multicode' end)  

--print @Count  
--print @Outcome  

set @Count = (  
select Count(*)  
from (select * FROM BNFEMP AS X WHERE NOT EXISTS(  
SELECT * FROM DRUGEMP WHERE DRUGCODE = X.DRUGCODE)) as x)  
  set @Total1 = isnull(@Total,0) + isnull(@Count,0)
set @Outcome= (  
select case when @Outcome is null and @Count > 0 then 'BNFEMP'   
when @Outcome is null and @Count = 0 then 'No records'  
when @Outcome is not null and @Count = 0 then @Outcome  
else @Outcome + '; BNFEMP' end)  

--print @Outcome  

set @Count = (  
select Count(*)  
from (select * FROM MANDEMP AS X WHERE NOT EXISTS(  
SELECT * FROM DRUGEMP WHERE DRUGCODE = X.DRUGCODE)) as x)  
  set @Total1 = isnull(@Total,0) + isnull(@Count,0)
set @Outcome= (  
select case when @Outcome is null and @Count > 0 then 'MANDEMP'   
when @Outcome is null and @Count = 0 then 'No records'  
when @Outcome is not null and @Count = 0 then @Outcome  
else @Outcome + '; MANDEMP' end)  

--PRINT @Outcome  

set @Count = (  
select Count(*)  
from (select * FROM PACKEMP AS X WHERE NOT EXISTS(  
SELECT * FROM DRUGEMP WHERE DRUGCODE = X.DRUGCODE)) as x)  
  set @Total = isnull(@Total,0) + isnull(@Count,0)
set @Outcome= (  
select case when @Outcome is null and @Count > 0 then 'PACKEMP'   
when @Outcome is null and @Count = 0 then 'No records'  
when @Outcome is not null and @Count = 0 then @Outcome  
else @Outcome + '; PACKEMP' end)  

--PRINT @Outcome  

set @Count = (  
select Count(*)  
from (select * FROM NAMEMP AS X WHERE NOT EXISTS(  
SELECT * FROM DRUGEMP WHERE DRUGCODE = X.DRUGCODE)) as x)  
  set @Total1 = isnull(@Total,0) + isnull(@Count,0)

set @Outcome= (  
select case when @Outcome is null and @Count > 0 then 'NAMEMP'   
when @Outcome is null and @Count = 0 then 'No records'  
when @Outcome is not null and @Count = 0 then @Outcome  
else @Outcome + '; NAMEMP' end)  

--PRINT @Outcome

set @Output = @Outcome
set @Total = cast(isnull(@Total1,0) as varchar(10))

I've also set the SSIS package to accept output parameters; see below. In case you were wondering the only way I could get the step to run in SSIS was if the @Total variable was varchar, it didn't seem to like INT, Float or anything else I tried.

My issue is that if the @Total field comes back with anything > 0 then I need to stop the package and show the output from @Output and I can't find anywhere how to do this.

Any ideas greatfully received, if I've gone about this completely the wrong way I'm more than happy to start again.

Many many thanks.