Subject:Importing XMl to single SQL Server table Author:Danny Costa Date:11 May 2007 03:06 AM Originally Posted: 11 May 2007 03:04 AM
This is not really a Stylus Studio question but because so many XML dudes hang out here, and my posts in other forums have been met with silence, I'm asking...
I'm a pretty experienced SQL DBA, but a real newbie when it comes to XML stuff.
I need to bring in data from an XML file into a single SQL 2005 table. I've spent too many hours to finally figure out a schema mapping file which doesn't error but when I run the SQLXMLBulkLoad my table remains empty.
My source XML is attached, the one called V3_INVRPT.XML.
My schema is attached, the one called InvMapping.xml
And I have the vba file I run to load it into SQL.