Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-12 : 09:47:01
|
| ian writes "I have created a DTS and it runs if I execute it manualy, but if I schedule it to run it fails everytime. I even tried to use the sa account and logon to automate it." |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-03-12 : 15:01:33
|
| MSFT has a specific knowledge base article that deals with issues relating to this general scenario. You'll need to post the exact error message and be more specific with what's happening, but it is usually a permissions or references problem.The key question is: when you "run it manually", do you do it from the server console or your machine through Enterprise Manager. Remember that any local references in DTS packages ( like pathnames and COM objects ) are resolved to the machine that's running the package, NOT the server. |
 |
|
|
|
|
|
DTS Automation