• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 546
  • Last Modified:

How to view DTS package logs in Sql 2005 Management Studio ?

How to view DTS package logs in Sql 2005 Management Studio ? Please let me know if there are any UI designer tools to view the DTS Package logs in SQL Server 2005...I don't need the sql statements to view the package logs in SQL Server 2005.
0
sridhar_ravva
Asked:
sridhar_ravva
  • 3
  • 2
  • 2
1 Solution
 
cyberkiwiCommented:
The long and short -
SQL Server 2005 Management Studio does not provide UI features for viewing SQL 2000 DTS package logs.

However, you you change your mind knowing that and want the T-SQL, then

SELECT * FROM msdb.dbo.sysdtspackagelog
SELECT * FROM msdb.dbo.sysdtssteplog
SELECT * FROM msdb.dbo.sysdtstasklog
0
 
sridhar_ravvaAuthor Commented:
I know these sql statements but I want the tool to view these DTS Package logs...can somebody tell me if there is any tool for that...for SQL Server 2005 to view the DTS Package logs.
0
 
cyberkiwiCommented:
The question was: How to view DTS package logs in Sql 2005 Management Studio ?
The domain was: in Sql 2005 Management Studio
The answer is categorically: no

Sorry to disappoint.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Anthony PerkinsCommented:
>>Please let me know if there are any UI designer tools to view the DTS Package logs in SQL Server 2005<<
In case you missed it the first two times, the answer is still no.
0
 
Anthony PerkinsCommented:
P.S.  And please do not award me points, cyberkiwi has already given you the answer.
0
 
sridhar_ravvaAuthor Commented:
Thanks for the suggested solutions. Appreciated much.
0
 
sridhar_ravvaAuthor Commented:
Thank you for the suggestions, appreciated.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now