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.
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
Explain what is SSIS? Mention what are the important components of SSIS package? Explain what is Solution Explorer in SSIS? Explain what does it mean by data flow in SSIS? Define what is “task” in SSIS? Explain what is SSIS package? List out different types of connection or files that support SSIS? Explain what is […]