asmyatt
asked on
Import XML files into SQL
Experts,
I need to import multiple XML files into a single SQL table. I need two things:
1) I need SQL query to create a table in SQL from the XML file so I dont have to manually create the table.
2) I need SQL import query to import bulk XML files into the table created in (1). All the XML files will be saved in the same folder. I will schedule the import to run once a day so the SQL import query would import in all XML files received that day.
See attached two example XML files that we get from third parties. The XML file is suppose to be a standard format. Any ideas?
Thanks.
70DAVIES-CA-EMP.XML 80BOTKIN-LD.XML
I need to import multiple XML files into a single SQL table. I need two things:
1) I need SQL query to create a table in SQL from the XML file so I dont have to manually create the table.
2) I need SQL import query to import bulk XML files into the table created in (1). All the XML files will be saved in the same folder. I will schedule the import to run once a day so the SQL import query would import in all XML files received that day.
See attached two example XML files that we get from third parties. The XML file is suppose to be a standard format. Any ideas?
Thanks.
70DAVIES-CA-EMP.XML 80BOTKIN-LD.XML
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Kevin Cross
I am not as SSIS savvy as I should be, so that should probably be #1 choice; however, I would probably end up one of the first two at the moment (that may change if I dive into the SSIS pool more -- again, as I think it is a good idea). Specifically, I would move data to a table containing an XML column and then I would do parsing in a routine as needed from there.
ASKER
I'll have to dig into this - apparently not as easy as I was hoping...