July 10, 2006 at 10:44 am
Hello,
I have multiple jobs scheduled to run on a weekly basis and until recently, have run successfully for years. Per the error received, the "folder does not exist on is not accessble". The folder does exist and I have full control of it so I know this isn't the problem. Below is a copy of the job history, which details the error message received. Hopefully, someone can assist me with this problem. Thank you.
Executed as user: FIT-DBSERVER\SQLSERVER. ...ing... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSFTPTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnError: DTSStep_DTSFTPTask_1, Error = -2147220489 (800403F7) Error string: Folder \\Server\LABFILES\Folder\WeeklyLTKRequest\ does not exist or is not accesible on destination. Error source: File Transfer Protocol Task Help file: Help context: 0 Error Detail Records: Error: 0 (0); Provider Error: 0 (0) Error string: Folder \\Server\LABFILES\Folder\WeeklyLTKRequest\ does not exist or is not accesible on destination. Error source: File Transfer Protocol Task Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSFTPTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.
July 10, 2006 at 11:31 am
If you can run the DTS packages manually, but they fail as a scheduled job, then it points to a permissions issue for the user under which the DTS jobs are running on the server.
HTH,
Lynn
July 10, 2006 at 2:59 pm
Yes, I can run the packages manually successfully. My network login appears as the owner of the package and I use an sa account to access SQL Server. I am fairly new to SQL Server, can you advise me on where to look to verify the permissions?
July 10, 2006 at 3:26 pm
You job is probably running as sa, correct? If so, it is running under the security context of the account running SQL Server Agent. This user needs to have access to the folder \\Server\LABFILES\Folder\WeeklyLTKRequest. You may need help from a Windows Sys Admin to check and/or correct the permissions.
HTH,
Lynn
July 11, 2006 at 7:53 am
To find out the name of the account running SQL Server Agent, you can do one of the following:
1) Log into the physical database server
2) Under Administrative tools, choose "Services"
3) Open up the Properties for the "SQL Server Agent" service, you will see information about which account this services "logs in" as.
- OR -
From Enterprise Manager, under "Management" for the appropriate db server, right-mouse click on "SQL Server Agent" and choose "Properties". You will see information about which account the "SQL Server Agent" logs in as.
Norene Malaney
July 11, 2006 at 8:19 am
Thank you all for your assistance!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply