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 |
|
danyeung
Posting Yak Master
102 Posts |
 Posted - 2006-08-10 : 18:37:46
|
| I created a DTS Package. It worked fine if I right click on the DTS and Execute Package. It failed after I right clicked and Schedule Package and than right clicked on the job to Start Job from Management - SQL Server Agnet - Jobs. When I clicked View Job History, the error was "The job failed. The last step to run was step 1 (DTSPackageName).The DTS needs DSN. I assumed that if the DSN works when Execute Package, it should work when Start Job from scheduled DTS. Is this correct?Why did it fail from scheduled DTS? How do I see detail error message?Thanks.DanYeung |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-10 : 18:43:56
|
| To mimick what the job does, log into the database server (from TS, console, or some other method) using the same account as the SQL Server service, then run the DTS package from DTS designer. You'll be able to see the detailed error from there. The package is probably trying to get to something that doesn't exist on the database server or the account that the service runs doesn't have access to it.Tara Kizer |
 |
|
|
danyeung
Posting Yak Master
102 Posts |
Posted - 2006-08-10 : 19:36:22
|
| The DTS finished without error if I executed the package from the DTS designer. It got error only if it ran from Management - SQL Server Agent - Jobs.Thanks.DanYeung |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-10 : 19:40:35
|
| But did you log into the database server using the same account as the SQL Server service? It makes a difference to do this on the database server to test out why a DTS package has failed in a job. Please re-read my post.Tara Kizer |
|
|
|
danyeung
Posting Yak Master
102 Posts |
Posted - 2006-08-11 : 14:16:06
|
| I found the problem and wanted to share. Check out http://support.microsoft.com/kb/269074/EN-US/. If the DTS Package is run from designer, it runs on the workstation. If the DTS Package is run on job, it runs on the server. The problem was I didn't create DSNs on the server.DanYeungThanks.DanYeung |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-08-11 : 14:18:54
|
quote:
Originally posted by danyeung
I found the problem and wanted to share. Check out http://support.microsoft.com/kb/269074/EN-US/. If the DTS Package is run from designer, it runs on the workstation. If the DTS Package is run on job, it runs on the server. The problem was I didn't create DSNs on the server.DanYeungThanks.DanYeung
Tara told you that twice.CODO ERGO SUM |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-11 : 14:26:45
|
| Lol.Tara Kizer |
|
|
|
|
|
|
Why DTS failed from scheduled job?