• Hi,

    for the logging of individual rows containing errors, in your data transformation task use an OLE DB Destination Error Output connection (red arrow) from the destination for the valid input to the destination for invalid input.

    For logging the progress of the package, go to the menubar at the top, select SSIS - Logging, and you can configure logging to a destination set up in your package such as a database or a text file

    hth