Creating a Solution
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

Creating a Solution

In SQL Server Management Studio and Business Intelligence Development Studio, a solution is a container that groups and manages the projects you use when you develop end-to-end business solutions. A solution lets you handle multiple projects as one unit and to bring together one or more related projects that contribute to a business solution. For more information, see Solutions as Containers.

Solutions in SQL Server Management Studio and Business Intelligence Development Studio can include different types of projects. If you want to create an Integration Services package using SSIS Designer, you work in an Integration Services project in a solution provided by Business Intelligence Development Studio. For more information, see Introducing Business Intelligence Development Studio.

When you create a new solution, Business Intelligence Development Studio adds a Solution folder to Solution Explorer and creates files that have the extensions .sln and .suo.

  • The *.sln file contains information about solution configuration and lists the projects in the solution.
  • The *.suo file contains information about your preferences for working with the solution

A solution is automatically created when you create a new project in Business Intelligence Development Studio, but you can also create a blank solution and then add projects later.

© 2016 Microsoft