SSIS - What Is The Difference Between Control Flow and Data Flow In SSIS ?

Control Flow: 

Control Flow is part of SQL Server Integration Services Package where you handle the flow of operations or Tasks.
Let's say you are reading a text file by using Data Flow task from a folder. If Data Flow Task completes successfully then you want to Run File System Task to move the file from Source Folder to Archive Folder. If Data Flow Task failed then you want to send email to your users by using Send Mail Task. The Precedence Constraints are used to control the execution flow.

Data Flow: 

Data Flow is the part of SQL Server Integration Services Package, where data is extracted by using Data Flow Sources ( OLE DB Source, Raw File Source, Flat File Source , Excel Source etc.). After extacting data Data Flow Transformations such as Data Conversion, Derived Column, Lookup, Multicast,Merge etc are used to implement different business logics and finally written to Data Flow Destinations (OLE DB Destination, Flat File Destination,Excel Destination,DataReader Destination ADO NET Destination etc.)

3 comments:

  1. In my decade-long journey as a digital marketing and web design expert, I've seen companies of all sizes struggle with server selection. Choosing an affordable yet reliable dedicated server can be a daunting task. Therefore, many are wondering which dedicated website servers are the most affordable?

    ReplyDelete
  2. Hello. If you decide to use dedicated servers, I would recommend checking out dedicated server deals . They offer a wide range of dedicated server solutions with different configurations to suit different needs. Their servers are known for their reliability and excellent performance. Additionally, they provide comprehensive technical support, which can be crucial, especially if you are new to managing dedicated servers. I hope this suggestion helps you make an informed decision.

    ReplyDelete
  3. """Pesticides should be used as a last resort in pest control.""" Pest Control Oakville

    ReplyDelete