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.ToSt ring() + " ### "+ args.Exception. LinePosition.To String());


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 ValidationEvent Handler(object sender, ValidationEvent Args args)
{
XmlSchemaValida tionException ex = (XmlSchemaValid ationException) args.Exception;
XmlNode node = (XmlNode)ex.Sou rceObject;
}

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


Is their an other way ?
Thank you very much