Failed DTS Job

[hedgracer]

I have scheduled a dts job and have had repeated failures in trying to get it to run on a specific time schedule and when I click start job. The dts package runs just fine when I execute through DTS-Local Packages. Can anybody give advice about where to head next on this problem? Thanks.

Dave

 

[mrdenny]

Turn on the logging for the DTS package then let the job run it again. This will give you better error messages.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)