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 |
|
william_lee78
Yak Posting Veteran
53 Posts |
 Posted - 2006-12-17 : 22:24:07
|
| Hi All,I have encountered a strange problem on my DTS package. I have a DTS Package to archived my data into Excel file. I have schedule my DTS package to run on Sunday every week. it is running successfully without any issue. However, when error happen, the DTS package didn't log any information in windows event log. I did checked the option "Write completion status to event log" on my DTS Package. However, there is no information related to my DTS package on the windows application log. May I know what is wrong on my DTS package setting? Can someone help me on this.Thank you in advance for the help.Regards,William |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-18 : 03:18:44
|
| 1. Clear the Windows Application Log and try again2. Enable logging to SQLServer and then check sysdtspackagelog table3. Enable loggin to an external file and check the file for error.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
william_lee78
Yak Posting Veteran
53 Posts |
Posted - 2006-12-18 : 20:28:49
|
| Hi Harsh Athalye,Thank you for the reply. I will try out your suggestion.Regards,William |
|
|
|
|
|
|
No Event Log when DTS Package Fail