Tasks
A task can best be described as an individual unit of work. 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 develop your own tasks, but here are the current ETL tasks available
to you out of the box:
➤➤ 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.
➤➤ CDC Control Task: Maintains and interacts with the change data capture (CDC) feature
from SQL Server.
➤➤ Data Flow Task: This very specialized task loads and transforms data into an OLE DB and
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 task enables the examination of data; it replaces your ad
hoc data profiling techniques.