| Author |
Topic |
|
Jimmy1981
Starting Member
8 Posts |
 Posted - 2012-07-19 : 04:47:32
|
| 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?Many Thanks,Jimmy |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-07-19 : 07:03:24
|
| 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. |
 |
|
|
Jimmy1981
Starting Member
8 Posts |
Posted - 2012-07-19 : 07:18:04
|
| Hi nigel,How do i know which are the sql server service and agent accounts? |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-07-19 : 08:57:30
|
| Look at the services from control panel.==========================================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. |
|
|
|
Jimmy1981
Starting Member
8 Posts |
Posted - 2012-07-20 : 06:00:21
|
| 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. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-20 : 10:28:13
|
quote:
Originally posted by Jimmy1981
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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
Jimmy1981
Starting Member
8 Posts |
Posted - 2012-07-23 : 03:07:06
|
| 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) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-23 : 10:47:12
|
quote:
Originally posted by Jimmy1981
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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
Jimmy1981
Starting Member
8 Posts |
Posted - 2012-07-23 : 11:00:51
|
| 2008 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-23 : 12:00:22
|
| and dts package is also hosted on same server?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Jimmy1981
Starting Member
8 Posts |
Posted - 2012-07-24 : 03:03:00
|
| it is yes, both are 2008. |
|
|
|
|
DTS Fails as Scheduled Job