Datasheet

❑ Execute Package Task: Allows you to execute a package from within a package, making your
SSIS packages modular.
❑ Execute Process Task: Executes a program external to your package, such as one to split your
extract file into many files before processing the individual files.
❑ Execute SQL Task: Executes a SQL statement or stored procedure.
❑ File System Task: This task can handle directory operations such as creating, renaming, or
deleting a directory. It can also manage file operations such as moving, copying, or deleting files.
❑ FTP Task: Sends or receives files from an FTP site.
❑ Message Queue Task: Send or receives messages from a Microsoft Message Queue (MSMQ).
❑ Script Task: Slightly more advanced than the ActiveX Script task. This task allows you to
perform more intense scripting in the Visual Studio programming environment.
❑ Send Mail Task: Send a mail message through SMTP.
❑ Web Service Task: Executes a method on a Web service.
❑ WMI Data Reader Task: This task can run WQL queries against the Windows Management
Instrumentation. This allows you to read the event log, get a list of applications that are
installed, or determine hardware that is installed, to name a few examples.
❑ 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 an array of tasks 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 those tasks will be used in many examples throughout the book. Tasks are extensible, and you can
create your own tasks in a language like C# to perform tasks in your environment, such as reading data
from your proprietary mainframe.
Data Source Elements
The main purpose of SSIS remains lifting data, transforming it, and writing it to a destination. Data
sources are the connections that can be used for the source or destination to transform that data. A data
source can be nearly any OLE-DB-compliant data source 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.
A connection is defined in the Connection Manager. The Connection Manager dialog box may vary
vastly 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.
6
Chapter 1
04 584359 ch01.qxd 12/16/05 10:20 PM Page 6