sridhar_ravva
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.
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.
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.
In case you missed it the first two times, the answer is still no.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the suggested solutions. Appreciated much.
ASKER
Thank you for the suggestions, appreciated.
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