![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
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! |
![]() |
| Thread Tools | |
| Display Modes | |
| |