• subscribe
October 18, 2005 12:00 AM

5 Things to Know About Property Expressions

SQL Server Pro
InstantDoc ID #47908

Here are five things everyone should know about property expressions:

  • The runtime evaluates and applies property expressions only at certain times:
    • When loading
    • When saving
    • When the runtime calls validate on tasks
    • When the runtime calls execute on tasks
    • When a component calls AcquireConnection on connection managers
    • When a component calls GetEnumerator on foreach enumerators
  • They're available for almost all task, foreach enumerator, log provider, and connection manager writable properties.
  • They're available on a limited number of dataflow component properties.
  • They may not be used to modify variables.
  • They're automatically provided for all writable properties on custom components except for custom Data Flow task components.


ARTICLE TOOLS

Comments
    There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here
  • SP1?
    I know there is a SP1 for SQL 2008 R2 available....and there is a "feature pack" as well... ...
  • SQL database mirroring
    I have SQL Server 2008 R2 Enterprise 64bit on Windows 2008 R2 Enterprise 64bit.  Each SQL Server has...
  • Dell Compellent Disk Drive
    Does anybody has experience with Dell Compellent Disk Drive? Basically, this system manages all disk...
  • Sql server performance tuning
    I need to find a tool that help me to optimize sql server,queries,improve the performance and solve ...