Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
SQL Server 2005 SSIS Package Event History
7 views
Skip to first unread message
Joe K.
Dec 2, 2009, 5:41:01 PM12/2/09
to
I have several SQL Server 2005 SSIS packages. What tables or t-sql query
can I run against the MSDB database to obtain detail information about the
SSIS event history? Trying to resolve problems with several SSIS packages.
Please help me resolve this issue.
Thank You,
Todd C
Dec 3, 2009, 7:45:01 AM12/3/09
to
use MSDB
go
SELECT * FROM sys.tables
WHERE name like '%package%'
go
SELECT * FROM sys.tables
WHERE name like '%package%'
That should get you a list of system tables that you can query.
HTH
=====
Todd C
0 new messages