List of control flow items

List of control flow items

Ø  Foreach loop container

Ø  For loop container

Ø  sequence container

Ø  ActiveX script task

Ø  Analysis service execute DDL Task

Ø  Analysis service Processing DDL Task

Ø  bulk insert task

Ø  data flow task

Ø  data mining query task

Ø  data profiling task

Ø  execute packet task

Ø  execute process task

Ø  execute sql task

Ø  file system task

Ø  ftp task

Ø  message queue task

Ø  script task

Ø  send email task

Ø  transfer database task

Ø  transfer error message task

Ø  transfer job task

Ø  transfer login task

Ø  transfer master sp task

Ø  web service task

Ø  wmi data reader

Ø  xml task

List of maintenance and plan task

Ø  Backup database task

Ø  Check database integrity task

Ø  Execute t-sql statement task

Ø  History cleanup task

Ø  Maintenance cleanup task

Ø  Notify cleanup task

Ø  Rebuild cleanup task

Ø  Shrink database task

Ø  Update statistics task

Data flow task having three categories

Ø  Data flow source

Ø  Data flow transformation

Ø  Data flow destination

List of Data flow source

Ø  Ado.net source

Ø  Excel source

Ø  Flat file source

Ø  Oledb source

Ø  Raw file source

Ø  XML source

List of Data flow transformation

Ø  Aggregate

Ø  Audit

Ø  Cache transfer

Ø  Conditional split

Ø  Copy column

Ø  Data conversion

Ø  Data mining query

Ø  Derived column

Ø  Export column

Ø  Fuzzy lookup

Ø  Fuzzy grouping

Ø  Import column

Ø  Look up

Ø  Merge join

Ø  Multicast

Ø  Oledb command

Ø  Percentage sampling

Ø  Pivot

Ø  Row count

Ø  Row sampling

Ø  Script component

Ø  Slowly changing dimension

Ø  Sort

Ø  Term execution

Ø  term lookup

Ø  Union all

Ø  Unpivot

List of Data flow destination

Ø  ADO.net destination

Ø  Data mining model training

Ø  data record destination

Ø  Dimension processing

Ø  Excel destination

Ø  Flat file destination

Ø  Oledb destination

Ø  Partition processing

Ø  Row file destination

Ø  Record set destination

Ø  sql server compact destination

Ø  sql server destination