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.

[282 byte] By [jam281] at [2007-12-24]
# 1

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

That's a good question.

enricvives at 2007-8-31 > top of Msdn Tech,SQL Server,SQL Server Integration Services...
# 2
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

JamieThomson at 2007-8-31 > top of Msdn Tech,SQL Server,SQL Server Integration Services...
# 3
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 at 2007-8-31 > top of Msdn Tech,SQL Server,SQL Server Integration Services...
# 4

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

JamieThomson at 2007-8-31 > top of Msdn Tech,SQL Server,SQL Server Integration Services...

SQL Server

Site Classified