Datasheet

Chapter 1: Welcome to SQL Server Integration Services
8
Tasks
A task can best be described as an individual unit of work. In the previous XML package snippet these
are the
< DTS:Executable > nodes. Tasks provide functionality to your package, in much the same way
that a method does in a programming language. However, in SSIS, you aren ’ t coding the methods;
rather, you are dragging and dropping them onto a design surface and configuring them. You can also
develop your own tasks, but here are the current ETL Tasks available to you out-of-the-box:
ActiveX Script Task: Executes an ActiveX script in your SSIS package. This task is only to
facilitate conversion of legacy DTS packages that use this deprecated scripting method.
Analysis Services Execute DDL Task: Executes a DDL Task in Analysis Services. For example,
this can create, drop, or alter a cube (Enterprise and Developer Editions only).
Analysis Services Processing Task: This task processes a SQL Server Analysis Services cube,
dimension, or mining model.
Bulk Insert Task: Loads data into a table by using the
BULK INSERT SQL command.
Data Flow Task: This very specialized task loads and transforms data into an OLE DB, and now,
optionally, an ADO.NET Destination.
Data Mining Query Task: Allows you to run predictive queries against your Analysis Services
data - mining models.
Data Profiling Task: This exciting new task allows for the examination of data to replace your
ad - hoc data profiling techniques.
Execute DTS 2000 Package Task: Exposes legacy SQL Server 2000 DTS packages to your SSIS
package.
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: Sends or receives messages from a Microsoft Message Queue (MSMQ).
Script Task: This task allows you to perform more .NET - based scripting in the Visual Studio
Tools for Applications programming environment.
Send Mail Task: Sends 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.
❑
❑
❑
❑
❑
❑
❑
❑
❑
❑
❑
❑
❑
❑
❑
❑
❑
❑
c01.indd 8c01.indd 8 8/28/08 12:01:17 PM8/28/08 12:01:17 PM