Bulk insert

• MickyD

  SSCarpal Tunnel

  Points: 4601

  More actions

  September 7, 2005 at 3:21 pm

  #111649

  Hi everyone

  Basically I need to know how to execute an SQL server “BULK INSERT” from a file located on the shared drive via SQL agent ?

  SQL Server Agent executes background jobs as user “NT AUTHORITY\SYSTEM”.  However, if such a background job tries to access a file share (such as the “shared drive” \\server\location, then the SQL agent reports that the job failed with windows error 1317 “specified user does not exist”.

  Does the agent the account running the agent need special permissions on the share ?

  cheers

• Amit Lohia

  SSCertifiable

  Points: 6104

  More actions

  September 7, 2005 at 4:35 pm

  #588285

  yes. the account running the agent nees permissions to that shared drive

  ---

  Kindest Regards,

  Amit Lohia