var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: XML feed into database
I have been tasked on importing an xml feed into a sql server 2005 database. Now I am a network guy so I am completely clueless here.
Could anyone help?
Need to bring that into a database table (not created yet)
Any help would be appreciated
Start by reading SQL 2005 Books Online subjects regarding the new XML datatype and its supporting functions.
Thanks for the reply
I have tried to do this with SQLXMLBulkLoad
I have a mapping file and a file of xml info. I then attempt to execute with SQLXMLBulkLoad. I keep getting schema errors.
I tried the same code as on the samples from Microsoft and I still get schema erros, even with their sample code
Could it be a server issue? Or am I on the wrong track?
Thanks in advance
What is the text of the error messages you are getting?
Are you attempting to load data directly into production tables, or are you loading into staging tables first?