0

We have deployed one SSIS 2012 project with two ADO.Net Project Connection Managers. (There are five packages within the project.)

The project has a related Environment, with a variable containing a server name. I want to map the variable to the project connection manager ServerName property.

When I right-click on the SSIS project node in SSMS 2012, launching the Configure dialog box, I can locate the Connection Manager, and highlight it to see its properties, but ServerName is not visible in the Properties list.

Usually, the ServerName property is listed under the RetainSameConnection property. It's visible on other Project Connection Managers in the same project.

Why would this property be hidden, just for one Connection Manager?

0

I found the answer by opening the project with Visual Studio 2012.

Open the SSIS project in Visual Studio, and select the .conmgr file in the Solution Explorer pane. Use the context menu and select the "View Code" menu option. This will show the XML within the Connection Manager file.

In the XML, there was this tag:

<DTS:PropertyExpression
    DTS:Name="ServerName">@[$Project::my_server_name]</DTS:PropertyExpression>

The ServerName property was set via an expression!

This fact is not easily discernible via the Solution Explorer tree itself. When the conmgr file is selected, the Properties pane only displays the File Name and Full Path properties.

When you open a package that uses the Connection Manager, and select that Connection Manager within the package editor pane, the properties pane shows many other properties, including Expressions. The ServerName property will be visible in the Expressions list only if it has been set.

There are two ways to resolve this issue:

  1. Within the Visual Studio project, open a package. Select the Connection Manager from the package editor pane, and delete the Property Expression from the Properties pane.
  2. Remove the PropertyExpression tag from the .conmgr file with a text editor.

Either way, once the ServerName property is no longer set by an expression within the connection manager definition file, it is exposed as a configurable parameter in the Configure dialog box in SSMS 2012.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.