11

Closed

SSIS: Improved variable edit window

description

A better SSIS package variables editing window. I'd like to be able to see the description property and would like to see a "..." button where I can edit the expression (and see if that variable is evaluated as an expression).
Closed Dec 14, 2008 at 2:21 PM by furmangg

comments

wrote May 10, 2007 at 10:15 PM

Might be good to include the ability to change the scope.

JoeSalvatore wrote May 24, 2008 at 2:46 PM

I'd also like to see the following:
  1. Expression and package configuration highlighting extended to variables
  2. Where used feature to enable understanding what SSIS objects/properites/expressions are using the variable
  3. CHANGE scope of variable

JoeSalvatore wrote May 28, 2008 at 7:18 PM

Would also like to have the ability ,when applicable, to display the expression used and permit the expression to be edited (as the Expression Window/Pane is implemented)

furmangg wrote Jun 27, 2008 at 8:52 PM

adamtappis wrote Jul 3, 2008 at 2:31 AM

  1. Expression and configuration highlights
  2. A way to identify variables that are defined with the same name at different scopes i.e. defined at a package level and then overridden at a lower level. This can sometimes be done by mistake (if the wrong object happens to be highlighted at the time) and is difficult to spot

furmangg wrote Jul 17, 2008 at 6:54 AM

added expression and configuration highlights

furmangg wrote Jul 28, 2008 at 12:41 AM

Can now edit the variable expression just like in the Expression Window.

JoeSalvatore wrote Aug 11, 2008 at 3:09 PM

This really rocks!
It is now clear what variables are valued from package configuration and which ones use property expressions (on the variable's value property)!
The ability to modify the expression right from the listing of variables is a huge produtivity gain and the editor is better.
THANKS!!

JoeOrding wrote Mar 5, 2009 at 11:31 PM

It would be nice to be able to display the path for the variable properties in case you need to set it from DTExec. The only way to find out the path is to go through the configuration wizard until you get to the preview phase.

\Package.Variables[User::FileName].Properties[Value]

MatthewRoche wrote Mar 6, 2009 at 12:45 AM

I TOTALLY agree with JoeOrding's recent comment - this would be a KILLER addition to this feature.