I have stored procedures that extract data from SQL table.. In these procedures we have various conditions and for some conditions if they are met we have a GOTO which points to an Error and Prints the custom error..
So according to the stored procedure that is an error and it prints it out.
here is what it looks like
our code begins...
here is our code.....
then half way thru the code this is part of the code...suppose this condition occurs then goto ERROR2
IF (@LowDate >= @HighDate)
more code follows.....
at the end of the code these are the various error values which get pointed at..
PRINT 'Procedure ERROR : Since ManualOverride, Please Enter Both Date Parameters'
PRINT 'Procedure ERROR : Please ensure that the Low Date is earlier than the High Date'
PRINT 'Procedure ERROR : High Date cannot be null'
PRINT 'Procedure ERROR : Low Date MUST be null if doing a regular run'
In SSIS i am calling these procedures with the Execute SQL task,
So my question is now since some condition occurs and then in stored procedure it will GO TO and ERROR and print that Error, thats something like an error and should not happen.. so would this be still executed by SSIS (considering it as a succesful run of stored procedure )and the package continues to run or does SSIS throw an error too when this GO TO ERROR occurs in stored procedure..