CODEWITHSUNDEEP
sql-serverssisssrs-2012ssms-2012
Ash
Ash

Reputation: 1466

Delete entries from SSIS package execution report in SSMS (SQL Server Management Studio)

I've deployed SSIS packages into SSMS (SQL Server Management Studio) and tried to execute project. But, It failed to run due to some configuration errors.

In order to resolve issues, I changed configurations multiple times and executed SSIS project in SSMS. Now, issues resolved and job is running successfully.

However, execution information report shows lot of failure entries and I'd like to delete them.

enter image description here

Experts, could you please help with how to delete those entries?

Thanks in advance.

Upvotes: 1

Views: 4773

Answers (1)

Wendy
Wendy

Reputation: 660

Under 'Integration Services Catalogs', right click SSISDB - Properties, under 'Operations Log', 'Retention Period', by default installation, it is 365 days. You may adjust it. SQL Server will delete for you. It will delete all projects log, not just this project.

The other way is to delete records in database SSISDB tables. Not recommended.

Upvotes: 1

Related Questions