> 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!
>