Hi, I have an XML file and it's XSD file,whenI use an other tool (Stylus studio) the XML file is valide and weelformed. But in SSIS using XML taskusing the same XSD and XML I get a "False", so the XMl file is not valide. Have you an idea obout this thank you in advance

can you use a sample data ( one record ) does this work? Are you using any thing usual in the XML?

Hi, I have test it onlywith a record and it does not work, but it works with Stylus.

Can you give me a sample please

Hi, I can not, because they are confidential data and it is a very big XMLfile.

The XML Source uses the Microsoft XML parser, so perhaps the document isn't valid by it's standards. If you are familiar with C#, you can modify the following code to load and validate your XML doc with the MS parser. Code Snippet XmlReaderSettings settings = new XmlReaderSettings(); settings.Schemas.Add("YourSchema.xsd", XmlReader.Create(new StreamReader("c:\\YourSchema.xsd"))); settings.ValidationType = ValidationType.Schema; XmlDocument test = new XmlDocument(); test.Load(XmlReader.Create(new StreamReader("C:\\YourXMLDoc.XML"), settings)); if (test.SchemaInfo.Validity != System.Xml.Schema.XmlSchemaValidity.Valid) { //Not Valid } That might help determine what the problem is.

Here is an other Script Task example for validating an XML file: http://microsoft-ssis.blogspot.com/2012/08/validating-xml-file-against-xsd-with_6.html Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter