question

Hi,

        I am facing some issue with running the Bulk Insert script. Here is the detailed information.                     
                    
        I am making an installer which will run on exchange server. This server may have the sql server on another machine on network.                     
                    
        So what I am doing is, in my installer I am creating one Shared Folder and Replace that path in the sql script. and than execute the script.                     
                    
        See below example.                    

BULK

INSERT Accounts

FROM '\MYEXCHANGEMACHINE\DBScripts\Accounts.txt’

WITH

(

-- FIRSTROW = 2,

  FIELDTERMINATOR =  '`~',                    
                    
  ROWTERMINATOR = '\n'                    

)

GO

Here MYEXCHANGEMACHINE is my exchange server machine and DBScripts is my Shared Folder.

        But while I am running this script, I am getting following error.                     
                    
        **Cannot bulk load because the file "\\DT424\DBScripts\Accounts.txt" could not be opened. Operating system error code 5(Access is denied.).**                              
                    
         I searched a lot on google but no luck..                     
                    
        Any idea or any other alternate solution?