November 7, 2014 at 7:22 am
I have a package that imports and transforms xml files provided by a third party vendor. This process has been failing since the vendor changed attribute names in the XML root. The error I am getting is :
[XML Source [1283]] Error: The component "XML Source" (1283) was unable to read the XML data. The ':' character, hexadecimal value 0x3A, cannot be included in a name. Line 2, position 95.
Looking at the xml file it seem to be referring to the fact that the attribute name has a ":" in it :
<myxxxxxfeedsFeed version="1.0" timestamp="1415274068954" vend.jobrunner:myxxxxxfeeds-feed-job:jar:39.0.21="1346361368143" vend.jobrunner:myxxxxxfeeds-feed-job:jar:39.0.21="1415181005527" vend.jobrunner:myxxxxxfeeds-feed-job:jar:39.0.21="1415150563518" vend.jobrunner:myxxxxxfeeds-feed-job:jar:39.0.21="1415150563472" vend.jobrunner:myxxxxxfeeds-feed-job:jar:39.0.21="1415120627187" >
Looking at the last successful file that loaded the attributes looked like this:
<myxxxxxfeeds version="1.0" timestamp="1397742286114" cci="1346361368143" lci="1397664913644" ni="1397624288009" doi="1397624287994" hdi="1397594321521" >
Vendor tells ":" are allowed in the attribute name, is this true ?
November 8, 2014 at 4:56 am
imran 60091 (11/7/2014)
I have a package that imports and transforms xml files provided by a third party vendor. This process has been failing since the vendor changed attribute names in the XML root. The error I am getting is :[XML Source [1283]] Error: The component "XML Source" (1283) was unable to read the XML data. The ':' character, hexadecimal value 0x3A, cannot be included in a name. Line 2, position 95.
Looking at the xml file it seem to be referring to the fact that the attribute name has a ":" in it :
<myxxxxxfeedsFeed version="1.0" timestamp="1415274068954" vend.jobrunner:myxxxxxfeeds-feed-job:jar:39.0.21="1346361368143" vend.jobrunner:myxxxxxfeeds-feed-job:jar:39.0.21="1415181005527" vend.jobrunner:myxxxxxfeeds-feed-job:jar:39.0.21="1415150563518" vend.jobrunner:myxxxxxfeeds-feed-job:jar:39.0.21="1415150563472" vend.jobrunner:myxxxxxfeeds-feed-job:jar:39.0.21="1415120627187" >
Looking at the last successful file that loaded the attributes looked like this:
<myxxxxxfeeds version="1.0" timestamp="1397742286114" cci="1346361368143" lci="1397664913644" ni="1397624288009" doi="1397624287994" hdi="1397594321521" >
Vendor tells ":" are allowed in the attribute name, is this true ?
Quick thought, it is to my knowledge, valid in the latest edition of XML 1.0 and in XML 1.1, what version of sql server/ssis are you on?
😎
November 12, 2014 at 6:04 am
Hi, Im running on SQL Server 2008 R2.
November 12, 2014 at 6:45 am
imran 60091 (11/12/2014)
Hi, Im running on SQL Server 2008 R2.
Just tried this on SQL Server 2014 and it throws an error:
Msg 9456, Level 16, State 1, Line 1
XML parsing: line 1, character 95, multiple colons in qualified name
Think you better get back to the vendor and ask them to change this;-)
😎
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply