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