Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

XML Source Errors OUT Expand / Collapse
Posted Tuesday, July 2, 2013 10:13 AM


Group: General Forum Members
Last Login: Tuesday, December 23, 2014 9:35 AM
Points: 162, Visits: 572
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