SSIS Question:

Download Job Interview Questions and Answers PDF

Explain Difference between control flow and data flow?

SQL Server Integration Services Interview Question
SQL Server Integration Services Interview Question

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 Interview Questions And Answers PDF

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?