What is the best way to rename columns when creating tables using DTS?
Our application field names (data source) are not user friendly and
we wish to rename them in our sql server database. Please advise.
Thanks.

Not sure I understand where DTS comes in here.

Do you have a package that drops and recreates the entities before pumping
the data from the source to destination?

If you do then you will need to

1. Modify the CREATE TABLE script to make it have user friendly names
2. Modify the transformations for the each DataPump task as the metadata
will now not match the definition of your attributes. You could do this in
the Disconnected Edit feature of the package if you want but with a lot of
entities this may be prohibitive.


The easiest way may be to create your destination entities as you want them
then build the package.

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
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


"Sharon B" <SHARON.BUSTON (AT) SAUCONY (DOT) COM> wrote