Checkpoint in SSIS allows the project to restart from the point of failure. Checkpoint file stores the information about the package execution, if the package run successfully the checkpoint file is deleted or else it will restart from the point of failure.
To deploy SSIS package we need to execute the manifest files and need to determine whether to deploy this into File System or onto SQL Server. Alternatively you can also import package from SSMS from SQL Server or File System.
SSIS packages and all the associated tasks have a property called LoggingMode. This property accepts three possible values Disabled: To enable logging of the component Enabled: To disable logging of the component UseParentSetting: To use parent’s setting of the component