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.
Working with Solutions
For more information about how to work with solutions, click a topic in the following list:
- How to: Create a Blank Solution
- How to: Add an Integration Services Project to a Solution
- How to: Remove an Integration Services Project from a Solution
See Also
Concepts
Creating an Integration Services Project