|
 |
About Us | |
|
SSWUG Articles | |
 |
Articles | |
|
FAQ |
|
Administration | |
|
Backup/Restore | |
|
Connectivity | |
|
Development | |
|
General | |
|
Installation | |
|
OLAP | |
|
Replication | |
|
Transfer/move | |
 |
Trouble | |
|
SQL 6.5 |
|
Scripts | |
|
Tips | |
|
Test Exams | |
|
Advertise | |
|
Download | |
|
History | |
|
Search | |
|
Traffic | |
|
Related Links | |
|
||
|
|
||
 I can run DTS package myself, but cannot schedule it. Answer: It looks like you use LocalSystem account. This account has no network access. Try to use another account with the access to the network resources. When you tried to schedule DTS package, the appropriate job will run under the user account that the SQLServerAgent service is running under. For example, if SQLServerAgent service runs under the LocalSystem account, you cannot schedule DTS package, because the LocalSystem account does not have network access. So, to schedule DTS package, you should set the SQLServerAgent service to run under account, which has access to the network resources. Note. Before you schedule DTS package, the Schedule service must be started. To start schedule service on the Windows NT choose: Start -> Settings -> Control panel -> Services (choose Startup "Automatic" type) and Start. To start schedule service on the Windows 2000 choose: Start -> Settings -> Control panel -> Administration -> Services (choose Startup "Automatic" type) and Start. See also this link: How to troubleshoot DTS problems |