I have an XML file and an XSD defined for it. I am importing this XML file into SQL Server 2005.
The SSIS package runs fine but there is no data in the table. I'm creating the table on the fly through SSIS itself.
When I click on preview of OLEDB Task, it shows no data but the correct columns. I checked my mappings and everything else.
I search online and found some reference to namespaces, is there some sort of special namespace I need to put on the XSD or XML to import into SQL Server?
Please let me know.
Thank you, Slick
asked Mar 24, 2010 at 12:31 PM in Default
Hi You do not need any special namespace in the xml or the xsd for importing data using ssis.Pls make sure the xsd defines the right schema of the xml.Try to open the xml in a browser and see if you can view the data normally. Thanks, Kannan
answered Oct 22, 2010 at 09:04 AM