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