SSIS Question:

Explain Difference between control flow and data flow?

Tweet Share WhatsApp

Answer:

Control flow deals with orderly processing of individual, isolated tasks, these tasks are linked through precedence constraints in random order. Also the output for task has finite outcome i.e., Success, Failure, or Completion. A subsequent task does not initiate unless its predecessor has completed. Data flow, on the other hand, streams the data in pipeline manner from its source to a destination and modifying it in between by applying transformations. Another distinction between them is the absence of a mechanism that would allow direct transfer of data between individual control flow tasks.

Download SQL Server Integration Services PDF Read All 9 SQL Server Integration Services Questions
Previous QuestionNext Question
Explain Error Handling in SSIS?If you want to send some data from Access database to SQL server database. What are different component of SSIS will you use?