I've never posted to these forums and I know this is a "common" problem, but I'm struggling big time on it.
I've recently begun receiving xml files and ran into a small problem that seems syntax related, but I simply can't find where it is. Below is the xml file and sample code of what I'm doing. I cut up the xml data, it's far more
complex then what I'm presenting below. I think it has something to do what how I'm address eventId but am struggling with figuring it out. My preference is to stay out of SSIS if at all possible on this project.
I'm getting rows to return, but they are all null when there is data in the file.
If you see something with what I'm doing (and replied), I'd be greatly thankful.
<?xml version="1.0" encoding="UTF-8"?>
<media type="FLASH" url="xx.html"/>
View Complete Post