October 18, 2004 at 12:03 pm
Hi,
I am a beginner when it comes to DTS Packages and I need help. I have a package on the server that grabs a text file from a network drive every day and imports it in my database. When I run the package, this process succeeds but when I schedule it to run every day it fails. The error message says that it can find the path specified. I don't understand why it works when I manually execute the package and it fails if it is a scheduled job. Thank you very much for any responses.
October 18, 2004 at 1:00 pm
Dragan,
I would check and ensure that whomever is set to be the "run as" has permissions to get to the directory where the file lives. If this is running as sa you may have a problem.
Good Hunting!
AJ Ahrens
webmaster@kritter.net
October 18, 2004 at 10:55 pm
I ran into this problem a couple weeks ago. Found that if I gave the SQL machine (not a user) access to the folder on the network with all privs EXCEPT FULL CONTROL, then the SQL Server SYSTEM account could take care of business.
Butch
October 19, 2004 at 7:20 am
It also may be a mapped drive problem. When you run a DTS package from your system, it runs on your system and uses your client's mapped drives. The server may not have those drives mapped. Make sure to set it up as a UNC connection so the server can find it.
Michael Lee
October 19, 2004 at 7:25 am
Thank you very much for your replies. I will try your suggestions.
October 19, 2004 at 7:32 am
Also check to ensure that your package is running under a real user rather than the local administrator account.
October 20, 2004 at 7:39 am
When you schedule the job it runs under SQL Server Agent's security context. Check the account it runs under and make sure it has permission to access the network drive.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply