CODEWITHSUNDEEP
xmlxsdssis
Brandon
Brandon

Reputation: 11

XML SSIS Returning no rows

I have an SSIS package I created that is set up to pull in data from an XML file into 8 different SQL tables. It executes without an errors, but no data is passed to the SQL tables it's pointed to. The XML Source Editor would not generate and XSD file, so I used an online generator to create the XSD.

Anyone else have this issue?

Upvotes: 0

Views: 675

Answers (1)

Ako
Ako

Reputation: 1221

Most possible issue is that the namespace does not match with the namespace in the file.

Upvotes: 1

Related Questions