Re: Run DTS as Scheduled Job
Check that the SQL Agent service account has the correct permissions
on all objects used by the DTS package (files, folders, servers, etc).
90% of the "It works fine when run manually but fails when scheduled"
errors imo are caused by permissions (in DTS and SSIS)
Good luck!
J
.
Relevant Pages
- Re: ASP.Net Security Problems.
... the webroot is on ... That would lead me to believe that the OS folders that you mentioned have ... the correct permissions?? ... >>I've been able to narrow it down to a security problem ...
(microsoft.public.win2000.security) - Re: folder security rights
... > policy for assigning security rights to files and folders, ... Put the CORRECT permissions for defaults on each directory; ...
(microsoft.public.security) - schedule package problem
... I made DTS package to transfer datas between to servers (both SQL Server ...
(comp.lang.java.databases) - Copy sprocs to a remote server
... My objective is to copy sprocs created on my desktop to a remote database. ... Both servers are registered in DTS. ... I have created a DTS package. ...
(microsoft.public.sqlserver.dts) - Re: SMS Error Code 8235
... I have seen two cases of this - reboot of all servers - DCs fixed it - ... When I try to Extend the Schema ... > with extadsch.exe I get an error code 8235 in the log. ... > folder is created with the correct permissions as well. ...
(microsoft.public.windows.server.active_directory) |
|
