View Single Post
  #2 (permalink)  
Old May 25th, 2004, 06:26 PM
hortoristic hortoristic is offline
Authorized User
 
Join Date: Jun 2003
Location: , , .
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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