What is SSIS?
SSIS is a component of MSBI mainly used for data migration. It let us fetch data from various data sources (Extract), convert them to appropriate format (Transformation) and finally let them put into a final destination (Load). In short it let us perform ETL.
In SSIS what is the difference between Control Flow and Data Flow?
Control Flow defines the workflow. It defines what all tasks need to be defined and in which order.
Data Flow defines the flow of Data with a single Control Flow task (called Data Flow Task).
What else we can do with the help of SSIS other than these ETL process?
In Control Flow we will find a very useful task called Data Flow Task. It let us define our ETL process. But this is not the end, we have many other useful tasks such as ExecuteSQLTask (let us execute Sql queries), SendMailTask(let us send mail),MSMQ Task(let us work with MSMQ message. It let us send and receive messages from MSMQ), Backup Database Task etc.
In control Flow how you define the order of tasks?
We use Precedence constraints for this purpose. Using precedence constraint we define the flow of package. Flow will be based on the Success, Failure or completion of the last task.
In case you are new to MSBI , you can start with the below video of www.questpond.com which explains the basics of MSBI and also shows a simple example in SSIS.