Microsoft KB Archive/914805

= An expression that you defined in a data flow task does not appear in the Property Expressions Editor dialog box in SQL Server 2005 =

Article ID: 914805

Article Last Modified on 3/17/2006

-

APPLIES TO


 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Workgroup Edition

-





SYMPTOMS
An expression that you defined in a data flow task does not appear in the Property Expressions Editor dialog box in Microsoft SQL Server 2005.

Consider the following scenario:
 * You create a Microsoft SQL Server 2005 Integration Services (SSIS) package by using Microsoft SQL Server Business Intelligence Development Studio.
 * You add a data flow task to the package.
 * You add an expression for the data flow task. The expression refers to a property of an item that is contained in the data flow task.
 * You rename the referenced item.

In this scenario, you may notice that the expression that you defined does not appear in the Property Expressions Editor dialog box.



CAUSE
This problem occurs because the expression cannot be listed in the Property Expressions Editor dialog box when the name of the related item has been changed. However, the expression is still functional in the package. Therefore, you may experience various issues because you can no longer modify the expression. For example, if you delete a variable that is referenced in the expression, you will receive an error message when you try to build the package.



WORKAROUND
If you have not saved or executed the package, you can change back the name of the referenced item to work around this problem.

If you have saved or executed the package, the expression is lost. Therefore, you must re-create the expression by using the new name of the transformation.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



Steps to reproduce the problem

 * 1) Create a new SSIS package by using SQL Server Business Intelligence Development Studio.
 * 2) Add a data flow task to the package.
 * 3) Add an OLEDB source to the task.
 * 4) After the OLEDB source, add a Row Sampling transformation that is named RowSamplingName.
 * 5) Add an expression for the data flow task to set the expression to 1+1 for the [RowSamplingName].[SamplingValue] property.
 * 6) Save and then execute the package. Make sure that the package runs successfully.
 * 7) Rename the Row Sampling transformation from RowSamplingName to RowSamplingNewName.
 * 8) Open the Property Expressions Editor dialog box to view the expressions for the data flow task.

Notice that the expression does not appear in the Property Expressions Editor dialog box.

Keywords: kbtshoot kbprb kbexpertiseadvanced kbsql2005ssis KB914805

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.