Datasheet

Chapter 1: Welcome to SQL Server Integration Services
9
WMI Event Watcher Task: This task empowers SSIS to wait for and respond to certain WMI
events that occur in the operating system.
XML Task: Parses or processes an XML file. It can merge, split, or reformat an XML file.
There is also a whole set of tasks that are DBA - oriented, allowing you to create packages that can be used
to maintain your SQL Server environment. These tasks perform functions such as transferring your SQL
Server databases, backing up your database, or shrinking the database. Each of the tasks available to you
is described in Chapter 3 in much more detail, and you will see them in other examples throughout the
book. Tasks are extensible, and you can create your own custom tasks in .NET if you need a workflow
item that doesn ’ t exist or if you have a common scripting function that can benefit from reuse in your
package development. We cover this topic in Chapter 18, “ Programming and Extending SSIS. ”
Data Source Elements
The core strength of SSIS is its capability to extract data, transform it, and write it out to an alternative
destination. Data sources are the conduit for these data pipelines and are represented by connections that
can be used by sources or destinations once they ’ ve been defined. A data source uses connections that
are OLE DB – compliant and with SSIS 2008 this now includes ADO.NET Data Sources, such as SQL
Server, Oracle, DB2, or even nontraditional Data Sources, such as Analysis Services and Outlook. The
data sources can be localized to a single SSIS package or shared across multiple packages in BIDS.
All the characteristics of the connection are defined in the Connection Manager. The Connection
Manager dialog box options vary based on the type of connection you ’ re trying to configure. Figure 1 - 4
shows you what a typical connection to SQL Server would look like.
❑
❑
Figure 1-4
c01.indd 9c01.indd 9 8/28/08 12:01:17 PM8/28/08 12:01:17 PM