<div>
<div class="content wysiwyg-content">
Hello,<br />
i want show in a task a message when the event failure , i set a task with 2 arrows , the first if the task run ok and the second when failure, then set a new task &quot;script task&quot;, where i have a msgbox(?¿), &nbsp;and i want show here the reason of the failure (the same which shows the tab -execution results- of BIDS)<br />
<br />
any idea?
</div>
</div>


Hello,
i want show in a task a message when the event failure , i set a task with 2 arrows , the first if the task run ok and the second when failure, then set a new task "script task", where i have a msgbox(?¿),  and i want show here the reason of the failure (the same which shows the tab -execution results- of BIDS)

any idea?

ssis show execution results in a script

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

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.