Hi There,

I have around 10 DTS jobs which run every night. These jobs basically
copy data from views of a source DB to tables in a target DB. These
jobs have been failing quite frequently in the recent past. I have
checked and there are no contraint violations (like primary keys) in
the target DB. Most of the times I just start the job again and it runs
successfully.

The DTS job history does not give me any details and it says it exits
by code -1. I read online and have enabled SQL logging for the DTS jobs
today.

I want some suggestions if there are any best practices while creating
these jobs. And can you suggest what are the common reasons why DTS
jobs fail?

Thanks a lot for your reply!

Hello KKSMS,

The most common reasons can be found here


http://support.microsoft.com/?kbid=269074


Logging in the package should help.


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com