asked
No Rows Imported from XML File
I use a web service to connect to a third part and download data. The data returned is in an XML format. I have verified the webservice is connecting and downloading the data correctly. When I open the file in Notepad++ it is a properly formatted XML file. The file contains an inline schema, so an XSD file is not necessary. When I import data from the XML Source in the Data Flow i recognizes the columns, but now rows are returned. The data flow is simply empty. At this point I am completely stumped. Thank you in advance for any assistance. Here is a sample of the XML data including the inline schema. --- Med Check Med Check 4 Med Check
Hey gang, I'm desperate here. I know this topic has come up a lot, but none of the results I've found have been helpful. Refactoring the source or altering the web service that generates the file is not an option. It's a 3rd party, and their answer is "this is what we generate." The file contains inline schema information, and the columns are properly generated. It's just that the XML Source object does not see any data beyond the schema. Any help is appreciated.
ssis isn't really my thing. I take it you are expecting a single row like this (I didn't see form_name in the actual elements): form_name visittype label visittype_id description ---------- ---------- ------ ------------- ------------- NULL Med Check Med Check 4 Med Check
17 People are following this question.
