将复杂的XML文件数据存储到Table Sql server 2008 r2的最佳方法？ [英] Best Approach to store complex XML file data into Table Sql server 2008 r2 ?

问题描述

我要求我必须从一个共享文件夹中获取XML文件，并将每个节点值的数据存储在XML中，并存入Sql表，我需要做一个自动化的工作（每5分钟一次）。



1.我在谷歌检查SSIS，XML源我在这里每次看到我们需要手动生成XSD或点击生成XSD标签。但是自动作业不能这样做。



2.如果我选择存储过程来读取XML并解析，并插入表格。

我不知道这有什么副作用。



你能否提供建议动态执行此操作的最佳方法（自动作业）。



先谢谢!!!

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

推荐答案

最好选择Stored Procedure按节点读取XML节点并插入所需的表。这非常有效且方便。

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.

这篇关于将复杂的XML文件数据存储到Table Sql server 2008 r2的最佳方法？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！