Search results for query: *

Hello, Is it possible to get a return value in my VBScript when doing a bulk insert? if so, how is this done? Thank you, Kcrewjap

You are right, it worked perfectly. thanks you for all of your help.

This still doesnt combine the two tables into one.. desired records inserted in table: ct.xml 29820088 1234 ct.xml 29820089 5678 not ct.xml NULL NULL NULL 29820088 1234 NULL 29820089 5678 any help is much appreciated. Thanks

I'm trying to load an xml document into a sql server table using vbscript and sqlxmlbulkload. The xml file has a header element with the filename, date, record counts, etc, followed by transaction elements. I'd like to merge some of the header info with the transaction data but I can't figure...

I am using SQL 2000. trying to automate a job to pull data from a shared file to upload to my database...would bulk insert be the best route for this?