SSIS tasks

Today we will learn about various tasks which are available in SSIS. Before going to know about different tasks first will discuss about what is task.

Task: A task is a discrete unit of work that performs some action required in a package which may be moving a file or sending email or sending/Receiving file from FTP server. SSIS tasks are foundation of the control flow in SSIS. When you are on control flow tab SSIS displays set of controls which represents workflow of the package.

SSIS tasks are divided as following categories

Task Name	Task Description
Looping and Sequence tasks
Sequence Container	Used to group set of tasks as a single component.
For Loop Container	Used to loop through certain tasks in your package
Foreach Loop Container	Used to loop through collection of objects in your package.
Scripting tasks
Script task	This task allows us to perform .NET based scripting in Visual studio
Analysis Service Tasks
Analysis Services Execute DDL task	Used to execute DDL task in Analysis services(create, drop, delete cubes)
Analysis Services Processing task	Used to process Analysis service processes which are cubes, dimension or cube model
Data Mining Query task	Allows us to run predictive queries against your Analysis Services data - mining models
Data Preparation task
Data Flow task	This task is used to perform ETL (Extract, Transform and load) operations in SSIS package.
Data Profiling task	task allows for the examination of data to replace your ad - hoc data profiling techniques
File System Task	This task is used to perform Directory related or file related operations
FTP task	Used to Send/receives files from FTP server
XML Task	Parse or Processes XML file. It can merge, split or reformat XML file
Web Service task	Used to execute web methods on web service
RDBMS server tasks
Execute SQL task	executes SQL statement or SQL stored procedure
Bulk Insert task	Used to load data into table by using BCP utility in SSIS package
Backward Compatibility tasks
Execute DTS 2000 Package Task	Used to execute legacy 2000 DTS package
ActiveX Script task	Used to execute ActiveX script in your SSIS package. This task only used to conversion of legacy DTS package which uses ActiveX scripting method.
Work Flow tasks
Execute Process task	Used to execute external process in your package such as notepad.exe,command.exe
Execute Package task	Used to execute some other package with in the package
Message Queue task	Sends or receives messages from MSMQ(Microsoft Message Queue)
Send Mail task	Used to send mails using SMTP
WMI Data Reader task	This task executes WQL queries on Windows Management Instrumentation
WMI Event Watcher task	This task gives ability to SSIS to respond certain Windows event
SMO(SQL management object) administration task
Transfer Database task	Transfers  Database from one server to another server
Transfer Error Messages task	Transfers Error messages from one SQL server to another server
Transfer Jobs task	Transfers Jobs from one SQL server to another server
Transfer Logins task	Transfers SQL logins from one server to another server
Transfer Master Stored Procedures task	Transfers Stored procedures from one server to another server
Transfer SQL server objects task	Transfers SQL Objects(tables, views, triggers, procedures, User-defined functions..) from one server to another server

NOTE: Leave your comment if you like the post

Technorati Tags: SSIS,SSRS,task