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!!!