This Video Tutorial illustrates how to SSIS Package Logging method.
This method of logging is useful for SSIS 2005, 2008, and 2008R2. There are five types of logging providers within SSIS Package; Text files, XML, Windows Event Log, SQL Server, and SQL Server Profiler. List of event handlers can be selected and list of system variables such as source name, source id, package name, user id... can be selected for logging.
In this video you will learn how to enable Package Logging through SSDT or BIDS. Then you will learn how to configure logging connection manager and change the logging options through DTExecUI and DTExec. You will also learn how to change Logging Mode through DTExec command line in production environment.