XML - SQL Server Forums

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

Author

Topic

anaylor01
Starting Member

28 Posts

Posted - 2007-01-07 : 23:45:00

Can anyone help me figure out how to import this schema?

<?xml version="1.0" ?>
- 
- 
- <Schema name="ProductAlertResponse" b:BizTalkServerEditorTool_Version="1.5" b:root_reference="ProductAlertResponse" b:version="1.0" b:standard="XML" xmlns="urn:schemas-microsoft-com:xml-data" xmlns:b="urn:schemas-microsoft-com:BizTalkServer" xmlns:d="urn:schemas-microsoft-com:datatypes">
<b:SelectionFields />
- <ElementType name="Version" content="textOnly" model="closed">
<b:RecordInfo />
</ElementType>
- <ElementType name="TransactionID" content="textOnly" model="closed" d:maxLength="18" d:type="string">
<b:FieldInfo />
</ElementType>
- <ElementType name="TransactionHeader" content="eltOnly" model="closed">
<b:RecordInfo />
<element type="SenderID" maxOccurs="1" minOccurs="1" />
<element type="ReceiverID" maxOccurs="1" minOccurs="1" />
<element type="ErrorStatus" maxOccurs="1" minOccurs="0" />
<element type="DocumentID" maxOccurs="1" minOccurs="1" />
<element type="TransactionID" maxOccurs="1" minOccurs="0" />
<element type="TimeStamp" maxOccurs="1" minOccurs="1" />
</ElementType>
- <ElementType name="TimeStamp" content="textOnly" model="closed" d:type="dateTime">
<b:FieldInfo />
</ElementType>
- <ElementType name="SenderID" content="textOnly" model="closed" d:maxLength="18" d:minLength="1" d:type="string">
<b:FieldInfo />
</ElementType>
- <ElementType name="ReceiverID" content="textOnly" model="closed" d:maxLength="18" d:minLength="1" d:type="string">
<b:FieldInfo />
</ElementType>
- <ElementType name="ProductAlertResponse" content="eltOnly" model="closed">
<b:RecordInfo />
<element type="Version" maxOccurs="1" minOccurs="1" />
<element type="TransactionHeader" maxOccurs="1" minOccurs="1" />
</ElementType>
- <ElementType name="ErrorStatus" content="textOnly" model="closed">
<b:RecordInfo />
- <AttributeType name="ErrorNumber" d:type="string">
<b:FieldInfo />
</AttributeType>
<attribute type="ErrorNumber" required="no" />
</ElementType>
- <ElementType name="DocumentID" content="textOnly" model="closed" d:maxLength="40" d:type="string">
<b:FieldInfo />
</ElementType>
</Schema>

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-01-08 : 01:23:09

Are you referring to using it to type your xml in SQL Server 2055 by creating an XML Schema Collection? If so I'm pretty sure you cannot use an XDR schema (which is what that schema is). You need to convert it into a W3C standard XML Schema first, then add it to SQL Server with the CREATE XML SCHEMA COLLECTION statement.

See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cptools/html/cpconxmlschemadefinitiontoolxsdexe.asp
http://msdn2.microsoft.com/en-us/library/ms176009.aspx

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-01-08 : 01:51:53

quote:
Originally posted by snSQL

...SQL Server 2055...

do you have an advance copy?

www.elsasoft.org

anaylor01
Starting Member

28 Posts

Posted - 2007-01-08 : 02:03:11

I do have one. I guess it came with .net 2005.

anaylor01
Starting Member

28 Posts

Posted - 2007-01-08 : 06:15:31

Ok. I changed the name of the file to file.xdr. I opened it in Visual Studio. I used the XML file command to change it to xml. Copied and saved it as an xml file in notepad. I tested it in MS Access and it created all the tables no problem. Now how in the hell do I do that in Sql Server 2005??? It can't be this hard. It should be as easy as it was for Access.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources