Click here to Skip to main content
14,973,807 members
Please Sign up or sign in to vote.
3.67/5 (2 votes)
Hi,

I have a requirement that I have to take the XML file from one shared folder and store the data of each node value in XML into Sql table ,and I need to do this as a automated Job (for every 5mins).

1.I checked out in google for SSIS, XML source here I see every time we need to generate XSD manually or click on generate XSD tab.But automated job cannot expected to do like this.

2.If I go for Stored procedures to read XML and parse ,and insert into table.
I dont know what are the side effects by doinng this.

Could you please provide suggestions for the best approach to do this dynamically (automated job).

Thanks in Advance!!!
Posted

1 solution

Better go for Stored Procedure to read the XML node by node and insert into the required Table. This is very efficient and handy as well.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900