Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    18

    Unanswered: DTS data transfer and Update

    My DTS package transfers data mostly codes from temp to master table. The master table has 10 description fields for each of the codes. These description fields are then populated using update statements joined with 10 description tables. However, the update process is so inefficient since a single update statement takes several hours to finish.

    The second option is to populate description fields as codes are transferred from temp to master table using 10 left outer joins with description tables. But the result was unexpected. It's giving me more than twice as many records as there are in the temp table.

    What would be the best (efficient) approach for this situation? Would greately appreciate any help/thoughts.

    thanks.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I think I would create a view, unload the vie and bcp the data into the table in native format

    Do the code tables contain keys?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by jodjim
    a single update statement takes several hours to finish
    Then you must be doing something wrong...
    Quote Originally Posted by jodjim
    The master table has 10 description fields
    This sounds like awful design! Fancy posting the DDL of the table in question?
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •