Post reply

DTS Column Mappings

  • April 14, 2005 at 9:41 am

    #166576

    In this section, how do I set "Delete rows in destination table" as the default? It's annoying to have to do that for what seems like 100+ tables. (It's twice as annoying when you wind up with duplicates because you forgot to click "delete rows in destination table"...)

  • April 14, 2005 at 12:37 pm

    #552793

    I can't answer that question directly, but here's what I do:

    I have an "Execute SQL" step at the start of my data load DTS which issues a truncate on each of the staging tables that's goint to be loaded.  (I always load direct to raw staging/extract tables and use stored procs to move data from there to final destinations.)

    eg:

    TRUNCATE TABLE tablea

    TRUNCATE TABLE tableb

    TRUNCATE TABLE tablec

    TRUNCATE TABLE tabled

    TRUNCATE TABLE tablee

    GO

     

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

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