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.