SSIS+XML+XSD+C# : Detect and log errors

[NacerCREPUQ]

Hi every body,

While validating my xml file with an .xsd schema, i need to detect all errors in order to load the line of data (or the key) + the error message ...

then save it into a log file or idealy directly to a database.

Exemple:
ID Name Sex Age
1 Jo M L
2 Sandy F 18
3 Sam 1 30

Now, in my .xsd, the sex must be either M or F ... and the Age must be an integer.

so i need to detect that both lines 1 and 3 are not good according to my xsd.... however the line 2 is good.

In my Errors table, i need to log something like this (or anything else similar:

1 Age 'the value is not an integer'
3 Sex 'The value is not in the enum {M,F}'

Whe i used this, i got the what you can see in the images here attached. however it is not enough:
MessageBox.Show(args.Severity.ToString() + " *** "+ args.Exception.ToString() + " $$$ "+ args.Exception.LineNumber.ToString() + " ### "+ args.Exception.LinePosition.ToString());


Then, I used this code to access the xml node that contains the error. however the ex.SourceObject is always null. this is my problem....

public void ValidationEventHandler(object sender, ValidationEventArgs args)
{
XmlSchemaValidationException ex = (XmlSchemaValidationException) args.Exception;
XmlNode node = (XmlNode)ex.SourceObject;
}

I also posted my question here :
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/ca2ec8f7-2f36-48b7-956a-ddf819dba2a9


Is their an other way ?
Thank you very much