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
A package in SSIS is an organized collection of connections like data flow elements, control events, event handlers, parameters, variables, and configurations. You assemble them by either building it programmatically or by graphical design tools that SSIS provides.