Best way of logging in SSIS
logging, sql-server, ssis
Solution
If you're not going to have access to the production server, then SQL Server logging is your best bet by far. You'll have plenty of ways of viewing the logged information, for example via custom SSRS reports or web pages, or direct access to the tables if your DBA allows it. Also, the logs will be easier to search and filter when in a table.
Problem
There are 5 different types of logging in SSIS - Event Log - Text File - XML File - SQL Server - SQL Server Profiler I am in a production environment where developers do not have access to production systems. Which logging method should be my poison of choice, and why?