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 |
|
suresha_b
Yak Posting Veteran
82 Posts |
 Posted - 2008-10-22 : 04:12:30
|
| Is it possible to see the DTS package execution log/history. Something like SQL Server Agent job history. If yes how?I queried the table sysdtspackagelog, sysdtssteplog, and sysdtstasklog in msdb. But they are empty. But the DTS package is run by a SQL Server Agent job. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-10-22 : 07:38:01
|
| Open your DTS package. There in package properties activate logging and save your package.Next time after execution you can right click on your package and view the log.WebfredNo, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
suresha_b
Yak Posting Veteran
82 Posts |
Posted - 2008-10-22 : 08:59:30
|
| Thanks Webfred.The "DTS Packages available on the server" drop down list is empty. I think it is because the DTS package is saved in "Meta Data Services". Is there any way to log/view the execution of DTS packages stored in the Meta Data Services? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-22 : 09:10:08
|
| Check msdb..sysjobhistory |
|
|
|
suresha_b
Yak Posting Veteran
82 Posts |
Posted - 2008-10-23 : 02:13:28
|
| Hi Webfred,Your solution works!Earlier I was trying in wrong place.ThanksSuresh |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-10-23 : 07:34:40
|
my pleasure  No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
DTS package execution log/history