I am new to SSIS. I am using SQL Server 2012 and SSIS 2012.
I am exploring SSIS and have been trying to load an XML file to a DB table, but I am having some trouble. The XML has the following sort of structure:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><movieList>
<userID>1234</userID>
<userName><![CDATA[Zachary]]></userName>
<movies>
<movie>
<movieID>9001</movieID>
<name><![CDATA[Avengers]]></name>
</movie>
<movie>
<movieID>9002</movieID>
<name><![CDATA[Avengers 2: Age of Ultron]]></name>
</movie>
</movies>
</movieList>
The issue I am having is that on the XML Source Editor window, on the columns page, I do not see the userID or userName available. What I do see in the Output Name drop down is "Movies" and "Movie". While searching online for an answer I found that XML Source does not allow for handling root attributes, but I'm not sure if that's the issue I am having.
No comments:
Post a Comment