How to make the process fast?

• Charmer

  SSChampion

  Points: 14903

  More actions

  November 10, 2011 at 2:34 am

  #390823

  Hi Friends,

  two tables (TxtMaster,TxtDetail)

  i have two data flows

  in first, what i'm doing is filling up TxtMaster Table...

  in second, pulling two column values(those columns are "identity" columns) from Txtmaster into TxtDetail....

  i have almost 5 million records..

  this process takes times due to huge amount of data...

  it executes Txtmaster first and then TxtDetail...

  is it possible to do both the process simultaneously so that i can save some time...?

  Thanks,
  Charmer

• herladygeekedness

  SSCertifiable

  Points: 5878

  More actions

  November 10, 2011 at 8:04 am

  #1405781

  Can the process that fills TxtMaster also handle the column transforms?