Sql Server 2008 Package Execution reports

In later versions of SQL Server, it is easy to find execution history for an IS package to see why it failed etc.

But in 2008 R2, how do you find a package's execution history?

It depends on how that package has been deployed - and what logging has been enabled for the package. If the package was deployed to MSDB database there are some tables available where you might be able to get some information, but if deployed somewhere else then you need to rely on how that package logging was defined (if at all).

1 Like