I have very large XML files, that i need to load into SQL server 2000 databases.
I could make tree things (XMLBULKLOAD) or transfor the file (XML) into txt file and load into the database with BCP or bulkinsert.
People say that the two last options are more rapid.
Does any one know an app. that transforms XML into TXT files ou have some code that does this?