Understanding Visual Studio Solution Configuration Manager : Quick Tip

ByAdam Gilmore Updated on

Understanding the Visual Studio Solution Configuration Manager Dialog. Below is an example screenshot of a Visual Studio Solution Configuration.

This example shows a solution configuration called DEV. Within the project are two projects called Data_Integration and Data_Integration_Database. Associated with the DEV Solution configuration is the DEV Project Configuration of the Data_Integration and Data_Integration_Database projects. The Project Configurations associated with the Solution configuration can be changed to other Project Configurations.

The association means that when you build the Solution with the DEV Solution Configuration, you will actually trigger the build of the projects with their selected associated Project Configurations. Both DEV in this case.

The Build and Deploy check boxes indicates that the project is built/deployed when the Solution is built/deployed, using the selected Solution configuration. Note that the Data_Integration project is a SSIS project. SSIS projects don’t support the Deploy action, and so Deploy is not enabled.

More information visit How to: Create and Edit Configurations.

Adam Gilmore

Adam Gilmore is a Data Architect with 20 years' experience in the Data field. He writes for dimodelo.com and develops courses covering Data Analysis to Data Architecture.

Similar Posts

|

Override SSIS package configurations through an SQL Server 2008 R2 Job

ByAdam Gilmore

If you thought you could override an SSIS package’s configurations when running it through an SQL Server 2008 R2 Job… think again. In the SQL Server Job Step Properties dialog, there is a  Configuration tab that allows you to specify configuration files. The logical assumption is that this will override existing configurations with the same…

| | | | |

Conversations with Data Warehouse Experts – James Serra

ByMike Rabinovici

In this episode, it is my pleasure to speak with James Serra, Data Platform Solution Architect and Data Warehouse Evangelist at Microsoft.  He is a thought leader in data warehousing and data management with over 25 years of experience in data modeling, data governance, and development methodologies.  James is also a popular and prolific blogger…

|

Automate build and deployment of SSAS Cubes using MSBUILD

ByAdam Gilmore

This post describes how to use MSBUILD to automate the build and deployment of a SSAS Analysis Services Cube. This solution relies on calling Visual Studio (devenv.exe) from within MSBUILD to first build the Cube and then using the SSAS deployment wizard from the command line to deploy the Cube. The first thing to understand…

| | |

Configuring SSIS Projects for Deployment : Quick Tip

ByAdam Gilmore

When you build an SSIS Project, you can optionally also generate an SSIS deployment Utility. The Deployment Utility can be used to Deploy the SSIS Packages and Configuration Files on a Server. Below is an example SSIS Project configuration, which will trigger the generation of a Deployment Utility. In the image you can see that…

How to add a custom SSIS component to Visual Studio Tool Box

ByAdam Gilmore

This article discusses how to add a Custom SSIS Component to the SSIS Tool Box in Visual Studio, so you can use it in your Control or Data Flows. Custom components are often distributed as DLL files, so some manual installation is usually required. 1. Add the DLL to your system The SSIS BIDS toolbox locates components…

|

Improve performance of SSIS using defaultBufferSize

ByAdam Gilmore

[et_pb_section admin_label=”section”][et_pb_row admin_label=”row”][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left” text_font_size=”14″ use_border_color=”off” border_color=”#ffffff” border_style=”solid”] Use the defaultBufferSize setting to improve the throughput of SSIS package. Key things you need to know: Each component in an SSIS data flow is assigned a memory buffer. The default is about 10MB. When your source is a wide table (i.e. has many or large…

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.