SSIS: Stop SSIS package execution if any files missing
<p>I have a SSIS package which look for 8 files in a pre-defined location. Using script task I am checking if any files are missing? If any files are missing then I send an email stating files are missing. Now I want to stop the current package if any files are missing after sending email task.</p>

<p>From the Microsoft link:</p>

<ul>
<li><a href="https://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.runningpackage.stop.aspx" rel="nofollow noreferrer">RunningPackage.Stop Method</a></li>
</ul>

<p>I can see I can stop the ssis package by stopping the ssis service (from the SQL Server which is running SSIS Service) what I do not want to do as I am not sure if it will start the ssis service automatically again. Also I do not have permission to see and run the packages in the ssis server and test this way.</p>

<p>I am not sure about how to stop using DTEXEC tool either. I would appreciate any kind of help.</p>