<div>
You can use RAISERROR depending on return value of your code in t-sql code inside task.
</div>


You can use RAISERROR depending on return value of your code in t-sql code inside task.

Untitled.png

<div>
Thanks for this suggestion, I agree that this may be the best way forward... I was hoping that the component could handle this itself rather than relying on a script component? Also why is there no SSIS section on EE?
</div>


Thanks for this suggestion, I agree that this may be the best way forward... I was hoping that the component could handle this itself rather than relying on a script component? Also why is there no SSIS section on EE?

<div>
There is section for SSIS named SSIS_SSAS
</div>


There is section for SSIS named SSIS_SSAS

<div>
<div class="content wysiwyg-content">
I have an SSIS package which has a 'Execute SQL Task' componenet. This task calls some SQL and returns 0 if everything is OK and 1 if an error has been found. This code is all working as expected. What I am looking for is a way to fail the component if the return code is &gt;&nbsp;0.<br />
<br />
The 'Execute Process Task' has similar functionality where you can use the 'FailTaskIfReturnCodeIsNot<wbr />SuccessVal<wbr />ue' and 'SuccessValue' fields. I need the equivelent functionality for the 'Execute SQL Task'.
</div>
</div>


I have an SSIS package which has a 'Execute SQL Task' componenet. This task calls some SQL and returns 0 if everything is OK and 1 if an error has been found. This code is all working as expected. What I am looking for is a way to fail the component if the return code is > 0.

The 'Execute Process Task' has similar functionality where you can use the 'FailTaskIfReturnCodeIsNotSuccessValue' and 'SuccessValue' fields. I need the equivelent functionality for the 'Execute SQL Task'.

SSIS: Fail 'Execute SQL Task' container based on returned result.

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.