SQLXML Bulk Load from C# Doesn't Work
-
Seems that no matter what I try, I cannot get my bulk load to work. According to different info I've found around the internet that if you get this message: QueryInterface for interface Interop.SQLXMLBULKLOADLib.ISQLXMLBulkLoad failed. then you need to add [STAThread] to your code to ensure that it runs in a single threaded environment. I have done this and it doesn't work. I've also read that if you're getting this message, it means it can't find the assembly you're looking for. I have registered my assembly with RegAsm and with gacutil and that doesn't help either. What else is there? Here is my setup. I am using a vbscript to intantiate a COM+ component I created using C#. That instantiation is successful. That component processes my data and creates an XML file. It then uses the Interop.SQLXMLBULKLOADLib library to bulk load my xml file into the DB. When it goes to create the Interop.SQLXMLBULKLOADLib object I get the error message mentioned above. Any suggestions? Thanks. -Matt ------------------------------------------ The 3 great virtues of a programmer: Laziness, Impatience, and Hubris. --Larry Wall