How To Raise Notifications In SSIS Script Tasks?

Hey guys,

I created a script task in my package that checks for filenames of files that are to be processed by the package.

for example, File.txt contains a header row of "File.txt|03252006"

what my script should do is to check whether or not the actual filename matches the header record inside..

If File.txt has a header record of "readme.txt|03252006" then the script should raise an alert or notification but not fail the package..

I am lost here.. I have no idea how to access the SSIS package's events/alerts from within my script task..

my code looks something like this:



'Get Filename from File Connection String

Dim strFile_Name As String = strFile_Conn.Substring(strFile_Conn.LastIndexOf("") + 1, strFile_Conn.Length - (strFile_Conn.LastIndexOf("") + 1))

'Get Filename from header

Dim ReadHeader As StreamReader = New StreamReader(strHeader)

Dim HeaderFileName As String = ReadHeader.ReadLine()

ReadHeader.Close()

HeaderFileName = HeaderFileName.Substring(0, HeaderFileName.IndexOf("|"))

If strFile_Name <> HeaderFileName Then

<I don't know what to put here I should raise an alert or notification that the file identification failed.>

End If


Thanks in advance guys, I hope someone would be able to help me

Kervy