hi yitongzhang 

I have found, i have found don't worry, the query

SELECT message FROM sysjobhistory

WHERE run_status = 0 -- only failed executions

AND...

Ok guysssss.

I have founded the problem. I've tried your query output on a file, and the file gave me all the job steps failed message !!!!!!

The reason...

Hi Markus,

i've just tried your query...unfortunatelly there were rows, but empties!

That's very strange, i think your query is right however...

I don't know how to do, i've try with a failed job...

Hi,

yes i know that, in fact i don't want to solve dts problems but i want to realize a dts that would run the week-end to know what...

Hi Greg,

I've mentionned this table in the explanation...

I've ever seen it but it doesn't contain the history of the step of the job failed...

Another idea?

(Thanks)

Hi,

Ok, you are right, anyway thanks for the answer, next time (i hope not) i will give you the content of the package log

I, no this DTS is running as a step of a job, there are others steps after and before, but it stop at this step. The log file is put...