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
- Open SSMS (SQL Server Management Studio).
- Navigate to following node (Your Server> Integration Services Catalog > SSISDB > YourFolder > YourProject > YourPackage).
- 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.