Creating a new package inside a SSIS project: How to create a new package into a SSIS project?
In the tutorial Create a SSIS project: How to create a simple SSIS project? we discussed how to create a SSIS project. An empty SQL Server Integration Services project can not do anything. To make it meaningful, we need to create a package and have to implement the package. This tutorial shows only to create a package into a SSIS project. I will discuss the implementation of SSIS package into another tutorial.
Create a SQL Server Integration Services Package i.e. a SSIS package inside the SSIS project. We already have created a SSIS project named as UsefulTutorialClub. Now, our goal is to create a SSIS package and name it as MyFirstSSISPackage.
Note: If you do not know how to create a SQL Server Integration Services project, please read the tutorial Create a SSIS project: How to create a simple SSIS project?
Steps to create a new package:
Step 1: Right click on SSIS Package. A list of menu options will be popped up. Click on the first option i.e. New SSIS Package to start creation of a new SSIS package.
Step 2: You will see a new package has been created under SSIS Package. The package name will be like Package1.dtsk. This is the default package name. We want to rename this package. To rename the package, right-click on the package and choose Rename option form the menu options.
Step 3: Type the name of the package as you like. For our tutorial, we typed MyPackage.dtsx. dtsx is the file extension of SSIS package type. Each package of SSIS project, must be ended with a .dtsx extion. When you have done, hit on Enter key. And you will see the package has been created successfully.
Following the above steps, you can easily create a SSIS package into a SSIS project.