Hey,
I'm messing up with SQLXMLBulkLoad object and I'm kind of struck now. Here is what I'm doing....
I'm trying to bulk insert data from XML into my tables using SQLXMLBulkLoad object. I have everything setup including the wscript (.vbs) file that has to be called from SQL Stored procedure using xp_cmdshell to run the wscript as shell command . When I run the .vbs script file from my command prompt directly I'm successful in loading the data but when I use the same script thorugh xp_cmdshell in QueryAnalyser it doesnot load the data. No error as such but return output as NULL. The procedure creates the required tables with constraints before calling xp_cmdshell. Can someone help me with this issue. Any pointers is appreciated too.
I'm messing up with SQLXMLBulkLoad object and I'm kind of struck now. Here is what I'm doing....
I'm trying to bulk insert data from XML into my tables using SQLXMLBulkLoad object. I have everything setup including the wscript (.vbs) file that has to be called from SQL Stored procedure using xp_cmdshell to run the wscript as shell command . When I run the .vbs script file from my command prompt directly I'm successful in loading the data but when I use the same script thorugh xp_cmdshell in QueryAnalyser it doesnot load the data. No error as such but return output as NULL. The procedure creates the required tables with constraints before calling xp_cmdshell. Can someone help me with this issue. Any pointers is appreciated too.