lunes, 30 de abril de 2012 9:34
We've got a C# ASP.Net web application that takes CSV files, validates it and then processes it (insert/update into many database tables). We've found the performance to be very slow so are thinking of using SQL XML Bulk Load 4.0. Firstly, if anyone has had similar issues or has used SQL XML Bulk would you also suggest to use SQL XML Bulk loaded to get round this issue?
Secondly, looking at the examples it seems it can take a XML and by setting up an XSD it can update/insert records into database tables. However can this also be done using the .Net Managed Classes? Or do I have to use Invoke?
Thanks for any insight and help - it would be much appreciated.
Todas las respuestas
lunes, 30 de abril de 2012 10:40Usuario que responde
This is how to do it with VBScript. The libraries are the same:
How to import XML into SQL Server with the XML Bulk Load component
martes, 01 de mayo de 2012 10:40Thanks