CODEWITHSUNDEEP
sql-serverssisreportetlexecution
user45867
user45867

Reputation: 977

SSIS "Execution Report" error - 'Report invalid' -- intermittently comes up in SSMS - cause?

seems like every time in a blue moon, there will be a week straight where I can't view Execution reports for SSIS packages running in SQL Server. I will get a cryptic error message about:

The definition of the report is invalid

Here is a picture:

enter image description here

Assuming I can't figure out this cryptic error (maybe you can) -- what steps do I need to go through to ensure I can view Execution Reports for SSIS jobs? I have separate custom logging --- it's more for a "live look" of some running jobs. Thanks!

Upvotes: 0

Views: 934

Answers (2)

B. Mahoney
B. Mahoney

Reputation: 26

I was just having this very issue. The solution that worked for me was closing all SSMS windows and restarting Management Studios. I spent a few days failing to find a solution to the issue online before restarting the application so I hope this will save someone else that time.

Upvotes: 1

Hadi
Hadi

Reputation: 37313

You have to download and install SQL Server Shared Management objects to fix this issue.

SQL Server 2017:

Older versions of SQL Server, you can find it as a part of the Feature pack:

Upvotes: 0

Related Questions