Hi, I have searched and found many topics on this but still can't seem to get it to work.
My DTS runs fine when i am logged on and run through EM, yet when I set as a Job and run the job it fails.
The job creates a folder on another server and then moves files from the other server in to this folder. It is on the create folder command that it is failing with permission denied.
Can anyone offer some advice on how to get this working?
Try giving the sql server service and agent accounts permission on the folder.
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
The user that is set up in Agent service has got full control on the directory where the folder is to be created but still fails with permission denied.
The user that is set up in Agent service has got full control on the directory where the folder is to be created but still fails with permission denied.
what are other tasks that DTS is doing? Also is folder path a local server path or is it UNC path?
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
The DTS loops through each file on another server and adds it to a SQL table, once it has looped through all files it creates a folder and moves the files in to this folder.
All other tasks are completing with no problems other than the create and move part.
The path is \\servername\DocumentDirectory\Processed\(create folder here)
The DTS loops through each file on another server and adds it to a SQL table, once it has looped through all files it creates a folder and moves the files in to this folder.
All other tasks are completing with no problems other than the create and move part.
The path is \\servername\DocumentDirectory\Processed\(create folder here)
which is server version you're trying to run it on?
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
DTS Fails as Scheduled Job
Posted - 07/19/2012 : 04:47:32
