How to enable logging in SSIS Package

1. On the SSIS menu,
Right click —> click Logging.

2. Select a logging provider in the list, and then click Add.

3. In the Configuration column, select a connection manager to create a new connection manager of the appropriate type for the log provider. Depending on the selected provider, use one of the following connection managers:
For Text files use a File connection manager.
For SQL Server Profiler use a File connection manager.
For SQL Server use an OLE DB connection manager.
For Windows Event Log do nothing. SSIS automatically creates the log.
For XML files use a File connection manager.

4. Add the location of text files where you want to create log file.

5. Run the package and check the log.