Create Integration Services (SSIS) solution

One of our clients provided us with a bunch of Integration Services packages for upgrade. As all of them were part of the same SQL job, we decided to bundle them into a solution.

The solution (.sln) is a container that groups and manages the projects that you use. Within one solution you can have one or more projects. Note that when you create a new solution, it creates files that have the extensions, .sln and .suo. In this article, we`ll discuss how to create .sln

You can create it either in Visual Studio, or in Notepad (Notepad++).

Option 1: Create solution in Visual Studio

  1. Open Visual Studio. Make sure you`re using the version that is applicable to your SSIS packages version.
  2. From the Menu bar at the top of the app, select   File -> New -> Project
  3. Properly name the Project and save the file into the folder where the packages are.
  4. From the Solution Explorer, right click on SSIS packages and then choose the Add Existing Package option.
  5. In the window, browse for your packages. You need to load them one by one.
  6. They all will appear under SSIS Packages in the Solution Explorer.                                                               
  7. Save the Visual Studio work and close it.
  8. Go back to the folder where your packages are. The solution file is there.


Option 2: Create a solution in Notepad++

If you use our code from below, you can create the solution within seconds.

When you save the code, you  have to specify the file extension to be .sln. For example, name it Solution file.sln

Then a Visual Solution file will appear in your folder.

Microsoft Visual Studio Solution File, Format Version 12.00
# Visual Studio Version 16
VisualStudioVersion = 16.0.31229.75
MinimumVisualStudioVersion = 10.0.40219.1
Project("{159641D6-6404-4A2A-AE62-294DE0FE8301}") = "Solution file", "packages.dtproj", "{CA75BC30-6FAA-40ED-9D08-69CA843089E9}"
GlobalSection(SolutionConfigurationPlatforms) = preSolution
Development|Default = Development|Default
GlobalSection(ProjectConfigurationPlatforms) = postSolution
{CA75BC30-6FAA-40ED-9D08-69CA843089E9}.Development|Default.ActiveCfg = Development
{CA75BC30-6FAA-40ED-9D08-69CA843089E9}.Development|Default.Build.0 = Development
GlobalSection(SolutionProperties) = preSolution
HideSolutionNode = FALSE

Please, keep in mind a few things before proceeding:

  1. Adjust the solution version in lines 2 and 3 to your packages version. In our example, we create a solution based on Visual Studio version 16.0. Check all versions from in the Microsoft official documentation for Visual Studio releases. 
  2. Change the names in line 5. In the first box you choose your solution name. In the second, however, you have to point to the relevant proj file name. You should already have in the folder where your packages are.