Link to home
Start Free TrialLog in
Avatar of sridhar_ravva
sridhar_ravvaFlag for United States of America

asked on

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.
Avatar of cyberkiwi
cyberkiwi
Flag of New Zealand image

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
Avatar of sridhar_ravva

ASKER

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.
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.
>>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.
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks for the suggested solutions. Appreciated much.
Thank you for the suggestions, appreciated.