Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 XML source: Xsd default value problem

Author  Topic 

raj4582
Starting Member

16 Posts

Posted - 2010-06-02 : 06:51:57
Hi

I have a xml file which i am trying to parse using SSIS. I have generated the xsd file for the xml using Generate XSD function in XMl source. I modified the xsd for an element to have a default value. However the XML Source does not provide the default value when no value is provided for the xml element in the xml.

Is there something else which I should do to make XML Source read the default value from xsd.

Thanks in advance.



   

- Advertisement -