Datasheet

Figure 1-3
The SSIS Service handles the operational aspects of SSIS. It is a Windows service that is installed when
you install the SSIS component of SQL Server 2005, and it tracks the execution of packages (a collection
of work items) and helps with the storage of the packages. Don’t worry; you’ll learn more about what
packages are momentarily. The SSIS Service is turned off by default and is set to disabled. It only turns
on when a package is executed for the first time. You don’t need the SSIS service to run SSIS packages,
but if the service is stopped, all the SSIS packages that are currently running will in turn stop.
Custom Applications
Data Flow Task
Data Flow Task
SSIS Data Flow
Transformation Pipeline
SSIS Designer
SSIS Wizards
Object Model
ManagedNative
Task
Data Flow Task
Task
Tasks
Custom
Tasks
Log
Providers
msdb
Database
.dtsx File
Data
Sources
Enumerators
Task
Task
Container
Task
SSIS Runtime
SSIS
Service
Command Line Utilities
Transformation
Source Adapter
Destination
Adapter
Destination
Adapter
Source Adapter
Transformation
Transformations
Custom
Transformations
4
Chapter 1
04 584359 ch01.qxd 12/16/05 10:20 PM Page 4