Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

XML Source Errors OUT Expand / Collapse
Author
Message
Posted Tuesday, July 2, 2013 10:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:04 PM
Points: 162, Visits: 570
I am trying hard to get, data out of my XML file. I get this most not detail error message when I try to excute the task. I couldnt get much out of ERROR message.

I want to post it here and see if any one has any exprience in dealing with this

" The component "XML Source" (1) was unable to process the XML data. Derived types are not allowed to be declared in source Xml documents. See element "product" with the attribute "xsi:type=ProductWithReviews".
Error: 0xC0047019 at Data Flow Task 1, SSIS.Pipeline: component "XML Source" (1) failed the prepare phase and returned error code 0xC02092B
.

I am trying to push the attributes from XML file to a Flat file( Incase any one cares what I am trying to do).
Post #1469648
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse