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.
| Author |
Topic |
|
swoozie
Starting Member
25 Posts |
 Posted - 2014-11-03 : 09:44:48
|
| I have 2008 R2 SP2 SQL ServerChange in Need: I am not actually able to post the XML and Schema. I down load the XML, no issues. I then Use the XML Data flow task to import it. The way it is set up it imports into 4 different tables. I am having the issue here. The XML file\Schema actually has 5 tables identified in it. The 5th table is not needed however it also makes everything fail because it has a node, and a child node named the same thing.Example:[CODE] <xs:element minOccurs="0" name="Names"> <xs:complexType> <xs:sequence> <xs:element minOccurs="0" maxOccurs="unbounded" name="Name"> --Table <xs:complexType> <xs:sequence> <xs:element minOccurs="0" name="Name" type="xs:string" /> --Column <xs:element minOccurs="0" name="type" type="xs:string" /> <xs:element minOccurs="0" name="description" type="xs:string" /> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element>[/CODE]Because NAME is used both for the table name and the column name I am getting an Error, [XML [286]] Error: The component "XML" (286) was unable to process the XML data. The element "name" cannot contain a child element. Content model is text only.[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "XML" (286) returned error code 0xC02092B0. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.I want to be able to Skip it.I also tried to do this all by SQL Script Task but I an having issues transferring the variable for the Location. |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-11-03 : 11:31:44
|
| Please post the schema of your temp table and a sample of the XML data you downloaded. |
 |
|
|
|
|
|
XML From HTTP