Integration Services Expressions
Integration Services allows you to set values dynamically for fields using variables that are updated at run-time by other tasks. This facility is quite powerful and great in many respects; however, it does not solve all the real-life problems with population of configuration values. Developers must often evaluate a value for a task based on a value generated by another task. This requires that they write a custom piece of code to evaluate the required value, as the value generated by the first task can’t be directly used in the second task. For example, if you want to create a folder in which the update files you receive daily are kept, and you want to add a date part in the name of the folder, you must evaluate ...
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
