Does DTS for 2005 have anything like the Dynamic Properties Task that
2000 had? Maybe I'm just not looking in the right place or the name
has changed. I've found "Package Configurations", but it doesn't do
everthing that DPT did, like assign a property from a variable. I'm
sure it can all be done through a Script Task, but would rather not go
to all of the trouble.

stevewest1 (AT) gmail (DOT) com wrote:
Have a look at property expressions. Most tasks include an expressions
page in the UI, or get at them from the property grid. Connections and
enumerators also support expressions.

Variables can also be expressions. See the property grid for the
options, Expression and EvaluateAsExpression.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com