Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 914805 - Last Review: March 17, 2006 - Revision: 1.1
An expression that you defined in a data flow task does not appear in the Property Expressions Editor dialog box in SQL Server 2005
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.
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.
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.
Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
in the "Applies to" section.
Steps to reproduce the problem
- Create a new SSIS package by using SQL Server Business
Intelligence Development Studio.
- Add a data flow task to the package.
- Add an OLEDB source to the task.
- After the OLEDB source, add a Row Sampling
transformation that is named RowSamplingName.
- Add an expression for the data flow task to set the
expression to 1+1 for the [RowSamplingName].[SamplingValue]
property.
- Save and then execute the package. Make sure that the package runs
successfully.
- Rename the Row Sampling transformation from RowSamplingName to RowSamplingNewName.
- 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.
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
| kbtshoot kbexpertiseadvanced kbsql2005ssis kbprb KB914805 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate