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 |
|
tran008
Starting Member
38 Posts |
 Posted - 2005-02-01 : 17:12:32
|
| hello,I have an DTS file the work fine when excute directly from the package. However, when the DTS package is put in a SQL job and run, it hung. Is there a way I can trace the the job directly to see where it hang at? Sql agent is running fine with another job.thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-01 : 17:13:59
|
| When it is run as a job, the files must exist from the perspective of the database service and the SQL account must have access to it. Are both of these true? To test, log into the database using the SQL account and run the package from DTS designer. This simulates what is done via a job.Tara |
 |
|
|
|
|
|
sql job...