How to view SSIS Package execution log in Visual Studio / SSIS Catalog Execution / Job Log

View Visual Studio Execution Log

If you execute SSIS Package inside Visual Studio then perform the following steps to view log in text format.

After you execute package > Click Debug > Windows > Output

Copy text from Output window and save to text file.

View SSIS Catalog Execution Log

If your packages ran from SSMS under SSIS Catalog or via Job which is calling Catalog Packages then you can find detailed log using below method.

To view execution log for packages stored under catalog check this article

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.

View SQL Agent Log

If your packages not stored in SSIS Catalog then try to look under SQL Agent Job History see you find any useful log. 

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/