SSIS (SQL Server Integration Service) was released by Microsoft from SQL Server2005 and is now followed by each SQL Server version. It's a great tool for Microsoft BI Solutions, and we generally think of SSIS as the ETL (Extract Transform Load) utility, which is typically used to import data into a database. SSIS is more than a normal ETL, it is visualized, developed with Visual Studio, and the package file (*.DTSX) is in XML format.
SSIS provides control flow and data flow. A control flow, also known as a workflow or a task flow, is more like a workflow, and each component in a workflow is a task. These tasks are performed in a predefined order. There may be branches in the task flow. The execution result of the current task determines which branch goes along.
The data flow is a new concept. Data flow is also called pipelining, which mainly solves the problem of data conversion. The data flow consists of a predefined set of transformation operations. The starting point of the data flow is usually the data source (the source table); The end point of the data flow is usually the destination of the data (the target table). The execution of a data flow can be thought of as a pipelined process in which each row of data is part of the assembly line that needs to be processed, and each transformation is a processing unit in the assembly line.
The architecture of SSIS consists of four main parts: the Integration Services service, the Integration Services object model, the Integration Services Run-time and run-time executables and data flow tasks that encapsulate the data flow engine and data flow components ():
Initial knowledge of SQL Server integration Service