October 27, 2019 at 3:20 pm
<?xml version="1.0" encoding="UTF-8"?>
<rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#" xmlns:oslc_rm="http://open-services.net/ns/rm#" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:foaf="http://xmlns.com/foaf/0.1/" xmlns:ss="http://www.sparxsystems.com.au/">
<rdf:Description rdf:about="http://localhost:803/SQL/oslc/qc/">
<rdfs:member>
<oslc_rm:Requirement rdf:about="http://localhost:803/SQL/oslc/re/{44A8A0F8-DA69-4f73-8D1D-39595D812BAA}/">
<rdf:type rdf:resource="http://open-services.net/ns/rm#Requirement"/>
<dcterms:title>Test Test Test</dcterms:title>
<dcterms:description>Test Description.</dcterms:description>
<dcterms:identifier>{44A8A0F8-DA69-4f73-8D1D-39595D812BAA}</dcterms:identifier>
<dcterms:subject/>
<dcterms:creator>
<foaf:Person>
<foaf:name>First Name Last Name</foaf:name>
</foaf:Person>
</dcterms:creator>
<dcterms:created>2018-05-15 12:02:51</dcterms:created>
<dcterms:modified>2019-03-27 15:59:11</dcterms:modified>
<ss:alias>AAAAA000002200</ss:alias>
<ss:status>Approved</ss:status>
<ss:difficulty>Medium</ss:difficulty>
<ss:priority>Medium</ss:priority>
<ss:type>type</ss:type>
<ss:phase>1</ss:phase>
<ss:version>1.0</ss:version>
<ss:packageID>009</ss:packageID>
</oslc_rm:Requirement>
</rdfs:member>
</rdf:Description>
</rdf:RDF>
Hi is it possible to convert above rdf/xml data to sql server table? I am using exec sp_xml_preparedocument to load data to a variable and use openxml to select from variable. But it is not working.
When i try to use SSIS i get multiple namespace error.
Is there is way to convert it to sql or even csv/excel/txt?
October 27, 2019 at 3:24 pm
What is your question?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply