Hey,

I am renaming a table that is referenced in over 100 DTS packages. Is
there any (faster) way to do this other than one DTS package at a
time?

Thanks very much.

Mark Palfrey

Nope.

You will want to use the object model to do this. If you parameterise your
package then you won't need to care where the package itself points. At
runtime the real value would be substituted in. You would change it in 1
place and one place only

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Mark Palfrey" <mpalfrey (AT) focustg (DOT) com> wrote