In this example, we will go through an SSIS project and packages to explore the functionality and structure of these objects. We will create an SSIS package and explore the development environment features in SQL Server Data Tools (SSDT) for Integration Services. Perform the following steps to create a project:
Open SSDT and create a new project of type Integration Services Project. Name the project
Chapter 04 Integration Services.When the new project opens, you will see Solution Explorer, Package Designer, and SSIS Toolbox:
As you've just seen, the SSDT has a special design for the development of SSIS packages. The preceding screenshot shows each part of SSDT, and the description of each part is given as follows:
Package Designer: In the preceding screenshot, the package designer shows the Control Flow button.
Solution Explorer: The SSIS projects contain three folders. SSIS Packages is used as a location for SSIS package...