Wednesday, April 21, 2010

How to custom name a SSIS task ?

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.

No comments:

Post a Comment