June 30, 2012 at 11:05 am
Is there any table in 2005 that stores the package run history? I haven't enabled the loggin on and sysdtslog90 table is empty. Agent shows job/package ran sucessfully but I am missing some records in the table.
July 1, 2012 at 5:48 am
Please take a look at the ExecutionLog view; there are 3 views depending on the version of MS SQL you are using; this is the MSDN article, it may help you to understand the ExecutionLog views: Report Server Execution Log and the ExecutionLog3 View
Cheers,
Hope this helps,
Rock from VbCity
July 2, 2012 at 1:38 am
Rock from VbCity (7/1/2012)
Please take a look at the ExecutionLog view; there are 3 views depending on the version of MS SQL you are using; this is the MSDN article, it may help you to understand the ExecutionLog views: Report Server Execution Log and the ExecutionLog3 ViewCheers,
That is for reports, not SSIS packages.
@SQL_Surfer: when you schedule your packages with SQL Server Agent, you can use it's history to get the information. If info is lacking, you need to enable logging and configure the appropriate events to be logged. If that is yet not enough, it's possible you'll have to extend it with your own custom logging.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 2, 2012 at 7:30 am
Koen Verbeeck (7/2/2012)
That is for reports, not SSIS packages.
@SQL_Surfer: when you schedule your packages with SQL Server Agent, you can use it's history to get the information. If info is lacking, you need to enable logging and configure the appropriate events to be logged. If that is yet not enough, it's possible you'll have to extend it with your own custom logging.
True, I got confused
Hope this helps,
Rock from VbCity
July 2, 2012 at 10:36 am
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply