Re: Rename Destination Columns

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 06/04/04

  • Next message: Allan Mitchell: "Re: how to create csv file in DTA" 
    Date: Fri, 4 Jun 2004 09:44:24 +0100

    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@SAUCONY.COM> wrote in message
news:9507fed.0406031231.6eeca088@posting.google.com...
> 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.
  • Next message: Allan Mitchell: "Re: how to create csv file in DTA"

    Relevant Pages