Insert a message in the SSIS 2014 Catalog for reporting an error while integrating data
<p>I need a little help with SQL Server 2014 catalog.
I'm developping an SSIS package that will begin with a Script task that will check if the source files exist or not.
If the files needed do not exist I need to return a success as a package result but also need to write a message in the log saying that there was no source file or something..
Here is my test </p>

<pre><code> String FilePathEXOR = Dts.Variables["$FilePath"].Value.ToString() + "\\" + DateTime.Now.ToString("yyyyMMdd") + ".csv";

        if (!File.Exists(FilePathEXOR))
        {
            Dts.Variables["User::VAR_BOOL_File_Verif_EXOM"].Value = false;//Variable that will tell if we continue or not the package execution
            Dts.TaskResult = (int)ScriptResults.Success;
           //Writing Some message in the catalogue saying that we've passed the package to success but there was no integration because we didn't find the Source files 

        }
</code></pre>

<p>Thank you ...</p>