• It has to do with changes made to security in Vista and Win 2008 -

    documentation (this is post SQLXML installation):

    1)Update User Account Setting. Control Panel > User Accounts > User Accounts > Change User Account Control Settings > Set to lowest setting ‘Never notify’. Reboot.

    2)After reboot: Open command prompt (DOS). Type from C prompt: runas /env /user:adminaccountname “c:\program files\internet explorer\iexplore.exe” Enter. Type in account pwd when prompted.

    3)IE session will open up under the Service Account. Go to Internet Options under Tools >Advanced tab > Click Reset button. Close IE Browser for change to take place.

    4)Update script files. If machine is running SQLXML 3.0 then modify script to use: Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.3.0")

    If running SQLXML 4.0 then use Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.4.0")

    If running both SQLXML 3.0 & SQLXML 4.0 then use: Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.4.0")