I have two SQL2005 servers, one for delevopment the other live, when I try to bulk upload using the development server with the following code, it works fine:
DECLARE @sql VARCHAR(8000)
SET @sql =
WITH (FORMATFILE = ''C:\contacts.fmt'')'
However when I try to run the same code on the live server I get
Cannot bulk load because the file "\\hugo\wwwroot\damovo_demo\contacts\2100\contacts.csv" could not be opened. Operating system error code 1326(error not found)
I looked up this error and it suggests a login problem, but what I don't understand is that both servers access the remote machine and file in the same way, why does the live server have an issue?
Thanks for any help in advance
edit: sorry noticed I added to wrong section (VBscript)