|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Why DTS Package worked from designer but failed on job?
I created a DTS Package. It worked fine if I execute the DTS from DTS designer. 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).
Why did it fail from scheduled DTS? Thanks. DanYeung |
|
#2
|
|||
|
|||
|
Re: Why DTS Package worked from designer but failed on job?
Dear Dan.
Could you solve the problem?. I've a scheduled dts job with the same fail. Thanks. |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > Why DTS Package worked from designer but failed on job? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|