Overview of SSIS Package

Monday, December 14, 2009

• The SSIS package is the unit of work that is retrieved, executed and saved.
• Package is an organized collection of connections, control flow elements, data flow elements, event handlers, variables and configurations.
• SSIS includes SSIS Designer and SQL Server Import and Export Wizard, in addition to the SSIS object model for creating packages.
• A package typically includes at least one connection manager.