Yes. The password expired, and the user updated with a new one via Windows. Now we can't run xp_cmdShell and get the error above.

Its using Execute As "domain\user" currently, and that user is a sys admin

I'd love to add a step to the job, but I don't know what that step would be. How do I notify the Qlikview server to start its own update...

Thank you - just what I was looking for!

Aaahhhh....well now that you've pointed it out, it makes perfect sense, but I would never have tried that! Thanks so much!

Actually, I never did find a way around that using bulkload. Instead, I used the sp_xml_preparedocument and that worked really well.

I am new to reports, so I guess I can't make the connection - I don't see how creating a file share and data driven report lets me pass a...

Thanks a lot for the suggstions! It helps!

Its an Access front end for remote offices. The remote office has local tables that occasionally get refreshed from head office SQL tables, and they send their data into the...

I am looking for something in code rather than import/export. I want the user to click a button in Access which will refresh all the tables by getting the newest...

Thank you so much!

Working in VBA and using the SQL Bulk Import as follows :

Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")

objBL.ConnectionString = "provider=SQLOLEDB.1;data source=myDB;database=Test;uid=test_Admin;pwd=nelson"

objBL.Execute "C:\schema.xml", "C:\Project.xml"

I keep getting the same error which is:

Schema: relationship expected on "Project"

and...

I'm not doing a good job of explaining things!

I am trying to call the stored procedure through VBA (Access) and got these errors, so I tried to to test it...

Ok, I've changed it to text, but that doesn't solve my problem

Normally I use the parse button before trying to submit anything, and it didn't see a problem with that! Oh well, thanks again!