<div>
cool thanks, i was think too much about the problem.
</div>


<div>
<div class="content wysiwyg-content">
I am using a script task manager that removes a password from a file, then processes the file. <br />
what i want to do is exit the package if the file or the folder does not exist.<br />
<br />
i have tried &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dts.TaskResult = ScriptResults.Failure<br />
but the rest of the package continues to run.<br />
<br />
<br />
Thanks.
</div>
</div>


I am using a script task manager that removes a password from a file, then processes the file. 
what i want to do is exit the package if the file or the folder does not exist.

i have tried             Dts.TaskResult = ScriptResults.Failure
but the rest of the package continues to run.


Thanks.

SSIS Exit/Stop Package

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.