Tuesday, February 14, 2012

Changing default name in tasks ?

Best practice talks about the use of name conventions in the SSIS packages.

Is there a way to rename the default names of the tasks in the DataFlow and ControlFlow once and for all, so that each time I drag a new DataFlowTask in, the default name will be DFT and so on.

I suppose that programatically when you instantiates from ..Dts.Runtime.Package is possible (pkg.Connections.Item(0).Name...)

That's a good question.

|||

jam281 wrote:

Best practice talks about the use of name conventions in the SSIS packages.

Is there a way to rename the default names of the tasks in the DataFlow and ControlFlow once and for all, so that each time I drag a new DataFlowTask in, the default name will be DFT and so on.

Unfortunately not. That would be a nice-to-have though. perhaps you should suggest it at Microsoft Connect?

-Jamie

|||I think it would be a nice features, since every company have their own way of using name conventions - though i'm using yours Jamie :-)|||

jam281 wrote:

I think it would be a nice features, since every company have their own way of using name conventions - though i'm using yours Jamie :-)

That's good to know :)

Thanks

-Jamie

No comments:

Post a Comment