Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

LogProvider.SetExpression Method

Assigns the specified expression to the property. Specify a null reference (Nothing in Visual Basic) to remove an existing expression from the property.

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

public final function SetExpression(
	propertyName : String, 
	expression : String


Type: String
The name of the property to which to assign the expression.
Type: String
The expression.


IDTSPropertiesProvider.SetExpression(String, String)

The propertyName will be ConfigString, Description, or Name. For the log provider, those are currently the only three properties that can use an expression.

The following example sets the Description property of the log provider to be the text, "This is the log for…" with the current month and day appended to the end of the string.

No code example is currently available or this language may not be supported.

Sample output:

Current description: Writes log entries for events to a CSV file

Validation passed: Success

The expression for Description is "This is the log for January 06"

The description is now: This is the log for January 06

Community Additions

© 2015 Microsoft