Job failure

[jdgonzalez]

I'm hoping someone can help me out here. I created a DTS package that pulls data from DB to another. The DTS package works fine, but when I schedule to DTS package to run as a job, the job fails. Maybe I'm just looking in the wrong place but the error log just tells me what step was the last one to run. It's not really telling me what happened. Is there another place I should be looking for error logs? Does anyone know why this may be happening?

Any help would be greatly appreciated.

Thanks

 

[nigelrivett]

You can set the package to write a log.

When you schedule the package it will run under the profile of the sql server service (probably) or agent and that maybe doesn't have the correct permissions.



======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[JayKusch]

Open up your DTS Package in the designer again. The choose Package..Properties..Logging. On the screen presented near the bottom is a section called Error Handling. There you will be able to create an error log that will capture the info as your package runs.

Set that and then re-run your package. You should now get a better idea as to what is happening.

Thanks

J. Kusch

 

[jdgonzalez]

Thanks all. A few minutes after I posted I found where to enable that tracking. Turns out I wasn't pointing to a directory correctly and to make matters worse it was the last step to run in a nested package so (I guess) from a job stand point it ran without issue.