Is there any way I can have the db connection in my dts
packages set up as an alias name so if I need to move my
db schema to another database (in the same server) I don't
need to go in each connection and transformation and
change the db name. Thanks in advance for your help.

Sandra

In article <0e9601c38c37$316be3b0$a001280a (AT) phx (DOT) gbl>, Sandra
<silvah (AT) wellsfargo (DOT) com> writes
No you cannot alias databases. What you can do is use a global variable
to store the DB name and then use the Dynamic Properties Task to update
your connections with the global variable at run-time.

The DataPump task by default does use the three part name, and this will
of course override any changes you have made in connection. To avoid
this, just use Disconnected Edit to remove the database name. The UI
will put it back if you change the table again, but just be aware of
that. You could of course do this via script too.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Oops

I read DB Connection as Server. Should i have read it as Database ?

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Darren Green" <darren.green (AT) reply-to-newsgroup-only (DOT) uk.com> wrote in
message news:Kmj2QCD5Kcg$EwGy (AT) sqldts (DOT) com...

I really mean database not server. Thank you so much
anyway.