The last time we talked about creating my first package, the simple data from the database => database, and the Excel file => database process, let's take a look back at what fun elements are in a package:
We all know that many of the seemingly complex functions are made up of: order, selection, and circulation. SSIS is no exception, we can see in the SSIS package inside the Tools tab has written his essence:
The feature element inside the SSIS package contains the following illustration:
Control flow elements: control the overall order in which packages are executed, and how they are executed
Data flow elements: Controlling data load (where the data comes from, where to go)
Let's take a look at the control flow element: SQL Server Integration Services provides a container for the structure in a package, a task that provides functionality, and a three-part precedence constraint for connecting executables, containers, and tasks to sorted control flows: