View Single Post
  #3 (permalink)  
Old May 25th, 2004, 05:43 PM
niravp niravp is offline
Authorized User
Join Date: Jul 2003
Location: , , .
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts


Did you mean the remote server to be mapped correctly?

I have defined the flat file location as path = "\\\dtsfile\"&fileName&".asp"

Does SQL Sever Agent need a write permission to the folder? If so, how would you recognize SQL Server Agent i.e what would be the user id etc.?

Appreciate your help.


quote:Originally posted by hortoristic
 Remember when you run manually - despite opening the package from another server even, the package is running under your security and is running off of your instance of SQL Server. Also; any drive referances should use UNC's not letters - as drive 'F' to you may not be drive 'F' to SQL agent.

Joe Horton
Database Developer / Software Engineer
WISHA/Legal Services Software Development
Department of Labor and Industries
Voice (360) 902-5928 fax (360) 902-6200