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).