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
|