A package in SSIS is a collection of Tasks that may include Data Sources, Transformations, and Destinations that work together in a given order. Internally, the SQL Server integration services Package is a combination of Connection Managers, Control Flow Tasks, Data Flow Elements, Parameters, and Event Handlers used to perform ETL operations.
Each project contains multiple packages, and each package has the dtsx extension. The package is an independent workflow with its business logic or tasks. However, you can execute one package from another.
How to Create an SSIS Package?
When you create a New Project, BIDS automatically creates a new one. However, you have a choice to create a new package in SQL Server Integration Services.
The Package is all about extracting data from various sources, transforming it, and loading it totally different destinations. The following screenshot shows the package environment. Please refer to the Install Data Tools or BIDS article.
To do so, right-click on the Packages folder, and select the New option from the context menu. Also, read about Creating a new SSIS project.
It will create a new package, as shown in the below screenshot. The next step is to create SSIS Connection manager.
