How to export SSIS Package execution log

If your SSIS Package is deployed using Project Deployment Model and it SSIS Package is executed inside SQL Agent JOB then perform the following steps to export log in Excel format.

1. Open SSMS (SQL Server Management Studio).
2. Navigate to following node (Your Server> Integration Services Catalog > SSISDB > YourFolder > YourProject > YourPackage).
3. Right click on Package > Reports > Standard Reports > All executions like below.
   
   
   
4. Once Report is visible you can click on "All messages" link
5. Inside Report right Click > Export > Excel like below
   
   ​

Contact Us

If you have more question(s) feel free to contact us via Live chat or email to [e-mail]

https://zappysys.com/support/