April 14, 2003 at 6:38 am
I have created a job to execute a DTS package. The first step of the package is an FTP task.
When I execute the task myself everythings runs fine. When the package executes from the job I get the following error message.
DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSFTPTask_1 DTSRun OnError: DTSStep_DTSFTPTask_1, Error = -2147220489 (800403F7) Error string: Folder Y:\MarkBData\CaMIS output\Outpatient MDS\ 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 Y:\MarkBData\CaMIS output\Outpatient MDS\ 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.
I am trying to fine out if this is due to the mapped drive (I have tried remapping this using \\servername\ but still get the same message) or if this is because the sqlserveragent does not have permission to access the folder.
If anyone knows what I need to do to give the appropriate access this would be much appreciated.
Any other suggestions gratefully received!
April 15, 2003 at 1:57 pm
The user that runs the sqlagent service must have access to the mapped drive and the drive must be mapped on the server. Try mapping the drive with the user of the sqlagent or try to use the destination path like \\servername\sharedfolder
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply