question

gdroberts7518 avatar image
gdroberts7518 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
ssisxml
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
gdroberts7518 avatar image
gdroberts7518 answered
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.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.