The following diagram shows SSIS Designer and the Toolbox window. In addition, SSIS Designer includes the Connection Managers area for adding and configuring the connection managers that a package uses to connect to data. At run time a fifth tab appears that shows the execution progress of a package while it is running and the execution results after it finishes. SSIS Designer has four permanent tabs: one each for building package control flow, data flows, and event handlers, and one tab for viewing the contents of a package.
Adding event handlers to the package and package objects.Īt run time, viewing the execution progress of the package.Constructing the data flows in a package.Constructing the control flow in a package.You can use SSIS Designer to perform the following tasks: SSIS Designer is available in Business Intelligence Development Studio as part of an Integration Services project. SSIS Designer is a graphical tool that you can use to create and maintain Integration Services packages. Of the components shown in the above diagram, here are some important components to using Integration Services successfully: SSIS Designer
Now let’s explore them.Īs shown in the following diagram, Microsoft SQL Server Integration Services consists of diverse components. But to work with it we have to know about it’s architecture and different components in it. Integration services plays a major role in database. In this article we will learn the architecture of Integration Services and will know about it’s various sections and how they helps.
0 kommentar(er)
