October 2, 2008 at 10:48 am
I am encountering error message as
Schema:missing element definition
while running the schema mapping file.
Please advise.
The contents of the mapping file are:
Error Message: Error: Schema: missing element definition 'app1'
October 14, 2008 at 5:46 am
We can't see the contents of your file. Attach it to your thread as a text file please.
October 16, 2008 at 5:30 am
The xml file and the schema (xsd) are not the same. There is additional or missing data in the xml file; or else the rows in the xsd are not in the same order as in the xml file
October 20, 2009 at 1:40 pm
Hi All,
I have received XML Schema files for 3 Different Event Logs.
Now I need to define the DB/TRable in my SQLEXPRESS 2008.
The I need to pull the Log files from a FTP location and read them in to the DB/Table.
How can I do this ? Is there is any user guide for this ?
Regards
Sunil
October 21, 2009 at 4:03 am
Sunil,
In the future, please start a new topic with your question rather than piggy-backing off another thread.
SSIS is the best way to load an XML file into SQL server in my opinion. Use a Data Flow task with an XML source. The source can define your .xsd file for you automatically. Then run the package every time you have a file. You can do this manually or via a SQL job.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply