I dint know this was possible until I actually did it. Here is how -
1. Create the task in the SSIS package/dataflow/container
2. Create a variable, say, _sDFTaskName = "Template1"
3. In the properties tab, go to "Expressions" --> Choose the property "Name" and in the Expression tab, provide the variable name, say DFT_"+@[User::_sJobName]
4. Make sure to save and close and open the task/package. The dynamic name will reflect only then.
Wednesday, April 21, 2010
Subscribe to:
Post Comments (Atom)


No comments:
Post a Comment