SSIS Basic Architecture
Solution (Collection of projects) —> Project (Collection of packages) —> Package (Collection of tasks for ETL and admin operations)
Under Package, the following components are available −
- Control Flow (Containers and Tasks)
- Data Flow (Source, Transformations, Destinations)
- Event Handler (Sending of messages, Emails)
- Package Explorer (A single view for all in package)
- Parameters (User interaction)