So how it starts?
- · On Failure Email Notification
- · Logging for detail error information
From Where to Get Error Information?
- If you have not set up error email notification in your SSIS Package, Then DBA will be sending you the initial information from Job History (SQL Server Agent Job). Your company might be using different scheduler than SQL Server Agent. Most of the scheduler those I have worked with do provide Job History and Error Message Information.
- If you have set up the Error Email notification from SSIS Package itself, you will get the email from your SSIS Package with error information. Here is the link how to set up that.
- If we want to further look into error details, we need to check the logging file or log records in table. SSIS Provide different type of logging such as text file, SQL server table, xml etc. Here is the link how to set up Logging in SSIS Package. You should have access to see the information. If your SSIS Package is logging execution information to file system, then you need read permission to the folder where the log files are created. If you are logging information in SQL Server Table then you need read permission on table. When you deploy your Package to Production, Make sure you get the permissions so when your SSIS Package fails, you can go to those locations and look into log files or table to find out error.