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

Joe,

Did you mean the remote server to be mapped correctly?

I have defined the flat file location as path = "\\172.00.0.001\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.

Nirav


Quote:
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