Create a new SSIS project with Visual Studio 2019

How to create a new SSIS project and solution with Visual Studio 2019?

To develop SSIS packages, i.e., SQL Server Integration Services, you need an integrated development environment, called IDE. Visual Studio is the development environment provided by Microsoft. To create a new solution, a new project and a new SSIS package with VS2019, you need first to install Visual Studio 2019 and then install the Integration Services project extension.

How to create a new Integration Services project with Visual Studio 2019?

How do I create an SSIS solution and SSIS project? With Visual Studio Integration Services, creating a solution is like creating a container that groups your SSIS projects. An SSIS project groups together all the SSIS packages in the same project.

First, creating SSIS solutions and projects with Visual Studio allows you to group and organise the packages under development. But also, the connections by themes or functional areas. To create an SSIS project, follow these steps.

1. Open Visual Studio 2019

Click on the Start Windows button, search the programs or use the search bar and type Visual Studio 2019.

Visual Studio 2019 logo as displayed at start-up
Visual Studio 2019 logo as displayed at start-up

2. Create a new project

In the start-up screen, select Create a new project. Then validate. The type of project is chosen in the next step.

Create a new project with Visual Studio 2019 and configure it as an SSIS one
Create a new project with Visual Studio 2019 and configure it as an SSIS one

3. Select the Integration Services Project type

In the search bar, type Integration Services, then select the corresponding type from the list. If the project type does not appear, then check the installation of SSS projects in Visual Studio. Finally, validate to proceed to the next step of creating the SSIS project.

To summarise:

  1. Type Integration Services in the search bar
  2. Select the Integration Services Project type
  3. Click on Next to validate.
Create a new SSIS project with Visual Studio 2019
Create a new SSIS project with Visual Studio 2019

4. Configure the location of the new SQL Server Integration Services project

An SSIS project, or a Visual Studio project, is usually stored in a solution, a solution can contain several projects of different types. For example, a complete BI solution with a T-SQL project, an SSIS ETL project and a Tabular Model project.

You need to choose whether the .sln file of the solution project will be stored in the same folder as the SSIS project itself. In the example below, the box is checked, and the file is therefore in the same folder. In this case the solution has the same name as the SSIS project.

Configure the new Integration Services project and solution
Configure the new Integration Services project and solution

When creating a solution, project or SSIS package, it is advisable to rename them to avoid confusion. That is, do not leave the default names proposed by Visual Studio.

5. The project and the package are opened in Visual Studio

When the project is opened, the main navigation window is called Solution Explorer. To open it manually, go to the View menu and select Solution Explorer or use the shortcut CTRL+ALT+L.

The new SSIS solution, project and package in the Visual Studio 2019 Solution Explorer
The new SSIS solution, project and package in the Visual Studio 2019 Solution Explorer

SSIS solution and project files generated by Visual Studio

When the SSIS solution is created, a folder is created at the chosen location containing the solution and project. These include a .sln file and a .suo file. The SLN file is the solution file and the SUO file contains the user’s preferences and settings.

In the SSIS project folder, here it is C:\solutions\Integration Services Project, you will find the following SSIS project files:

  • Integration Services Project.database
  • Integration Services Project.dtproj
  • Integration Services Project.dtproj.user
  • Package.dtsx : the first SSIS package created automatically with a default name

From the Solution Explorer window, there is no need to create the first package manually. The system creates it automatically and gives it a default name: package.dtsx. It is strongly advised to rename it to avoid confusion.

6. Adding a new SSIS project to an existing solution with Visual Studio

To add a new SSIS project to your solution, there are three possible solutions:

Right-click on the SSIS project, click on Add and then on New Item
Right-click on the SSIS Packages folder, then choose New SSIS Package
To duplicate a package directly, select the package and do a CTRL+C then CTRL+V

7. Add a new SSIS package to an existing project

Finally, to create a new SSIS package in the SSIS project, right-click on an existing SSIS package and choose New SSIS Package.

Video tutorial to create an SSIS package

The illustrated tutorial with video steps to create an SSIS project and add a package.

Finally, you can modify the sampling parameters used in the packages to detect and manage the data type on Excel files to load with Integration Services.

Be the first to comment

Leave a Reply

Your email address will not be published.


*