Post reply

DTS default configuration

  • October 7, 2004 at 12:50 pm

    #59961

       I often use DTS tool to refresh databases between the servers. When you choose "Transform" data and “Column Mappings and Transformation” window opens, the default option is “Append rows to destination table”.  

    Question: Is there a way to change the default option to “Delete rows in destination table”. This way I wouldn’t have to go thru the transformation of dozens of tables every time I move databases around.

    Thanks

  • October 8, 2004 at 10:20 am

    #525983

    There's no way I know of to change the default in the wizard.  If you move data between the same databases often, you could save as a package with delete or truncate steps and just execute the package whenever you want.

    Greg

    Greg

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply