Datasheet

Chapter 1: Welcome to SQL Server Integration Services
6
ETL requirements with a new architecture that has expanded dramatically, as you can see in Figure 1 - 3.
The SSIS architecture consists of four main components:
The SSIS Service
The SSIS runtime engine and the runtime executables
The SSIS Data Flow engine and the Data Flow Components
The SSIS clients
❑
❑
❑
❑
Figure 1-3
The SSIS Service handles the operational aspects of SSIS. It is a Windows service installed when you
install the SSIS Component of SQL Server. It tracks the execution of packages (a collection of work items)
and helps with the storage of the packages. Don ’ t worry; we ’ ll get to explaining what packages are
shortly. The SSIS Service is turned on by default and is set to automatic. You don ’ t need the SSIS service
to be on to run SSIS packages, but if the service is stopped, the default behavior is for all the SSIS
packages that are currently running to also stop. (You can configure this service differently in the service
configuration if this is not the behavior you require.)
c01.indd 6c01.indd 6 8/28/08 12:01:16 PM8/28/08 12:01:16 PM