Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dan_coder
Starting Member
20 Posts |
 Posted - 2006-12-22 : 05:42:48
|
| Hi guys.I have a DTS with 10 steps. Sometimes, the third step stop and it blocked the total execution of dts. In the log, the step has a start time but not an end time and the run status is 0! In Sql Server documentation I read this value can be 1 or 2 or 3 or 4. What is 0 status!?!?!Tks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-22 : 06:35:01
|
| It seems that a severe error occured, so that the entire process thread locked down. Because of this, there is not log information written.What happens in step 3?Peter LarssonHelsingborg, Sweden |
 |
|
|
dan_coder
Starting Member
20 Posts |
Posted - 2006-12-22 : 11:30:10
|
| Third step imports data from a remote database. The strangest thing is that I launch this DTS using a VB.NET application. Normally, when there is an error in a step I log it in a log file. With this "severe" error my program seems terminated abnormaly and no rows written in log files! |
|
|
|
|
|
|
DTS Run Status=0 !?!?