Post reply

DTS Packages getdate() default value not copying

  • September 22, 2005 at 6:59 pm

    #165624

    Hi

     

    Ok i have a few tables that need to be moved from one database to another on the same server. When i run the DTS package to to drop tables and copy data overwrite excisiting data, there is a default value of getdate() one a few fields, this property doesnt come across with the tables any ideas on how to get this to happen.

    You cant just copy the data because the relationships on the tables. any ideas would be good.

     

    Thanks Craig

  • September 22, 2005 at 8:00 pm

    #592457

    Using DTS to drop and re-create the tables is not the approach you should be taking here.

    If you can't perform delete/update/insert statements to update the destination tables, then a better approach would be to truncate the tables before inserting the data.

     

    --------------------
    Colt 45 - the original point and click interface

  • September 23, 2005 at 12:01 am

    #592484

    You need to "Include Extended roperties" when "Create Destination Object" via DTS wizard.

     

    _____________
    Code for TallyGenerator

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

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