October 18, 2007 at 4:42 am
Folks,
May seem like a silly question but here goes. There is a job currently set-up in my org that imports XML documents into a table. The process has been created using a .net(I think its either vb or c++) module which uploads the document and inserts it into a table.
Is this the most efficent way of going about it or should I propose using SSIS and scheduling the job. I assume SSIS can retrieve the file name as well. Will I have to write a program (such as with VB script in 2000) to retrieve the file name etc or can I do it using T-SQL in SS2005?
Thanks in advance for you help,
Martin
November 17, 2007 at 5:41 am
Hi,
In my opinion let the software (your program) process the XML (retreive the children and for each create columns) before saving it whitin the table.
If you save the XML (like it is) to a column, it will a huge process to retreive your colums, and to apply your business rules.
Regards,
Ahmed
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply