Last post Jan 01, 2015 04:18 AM by supermannum1
Dec 29, 2014 04:20 AM|supermanNUM1|LINK
I can generate xml using c# or using template with data and save in physical location such as E:\Employee.xml.
I want to feed xml to mssql to get update data in mssql.
How can I feed xml to mssql?
Dec 29, 2014 09:32 AM|limno|LINK
Try something from this link:
Dec 29, 2014 09:52 PM|Michelle Ge - MSFT|LINK
According to your description, you want to import xml file into mssql, please refer to the code below:
LOAD XML LOCAL INFILE 'E:\Employee.xml'
INTO TABLE my_tablename(personal_number, firstname, ...);
Hope it's useful for you.
Dec 31, 2014 06:17 AM|supermanNUM1|LINK
Can I write application to push xml file to sql? Because inside the folder, there would be several xml which are to update, insert, delete data.
and i will set in sql agent to run with schedule for that application?
Jan 01, 2015 04:18 AM|supermanNUM1|LINK
This is how to feed xml files under folder to sql
how to create variable
Deleting xml files which already successfully feed
These all made my solution done