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


The information in this article 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

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 "Applies to" section.

MORE INFORMATION

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.
Modification Type:MajorLast Reviewed:3/17/2006
Keywords:kbtshoot kbExpertiseAdvanced kbsql2005ssis kbprb KB914805 kbAudDeveloper kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.