Pages

Men

rh

7/01/2012

What are all Work Flow Tasks in SSIS


Work Flow Tasks:
This tasks is used to prepare work flow in SSIS package.  It has different kinds of tasks. 
  •   Send mail task
  •   Execute Process task
  •   MSMQ Task
  •   Execute DTS 2000 Package Task
  •   Execute Package Task
Send Mail Task:
Used to send an email to SMTP server.
  
Execute Process Task:
Used to execute windows script executable (exe) in SSIS package.

MSMQ Task:
Used to send the message to MSMQ  Server.
or 
Used to read the text message from MSMQ.

Execute DTS 2000 Package Task:
This is used to call and execute DTS Package in SSIS environment.

Execute Package Task
This is used to execute SSIS Package in SSIS environment.

No comments :

Post a Comment