Import and Export Wizard

• ssismaddy

  SSCarpal Tunnel

  Points: 4850

  More actions

  June 23, 2008 at 1:19 pm

  #122268

  Hi all,

  I want to transfer data from 1 table to the other table. The table has around 20 million records. It just takes 5 mins to transfer data by using import and export wizard. But it takes around 15 to 20 mins by using dataflow task. I don't understand why it does take such a long time. Can anyone explain the reason...I wanted to use dataflow task in this pacakge...but it takes long time... 🙁

  Thanks in advance..

• pduplessis-723389

  SSChampion

  Points: 10599

  More actions

  June 24, 2008 at 12:02 am

  #833152

  Why dont you save the SSIS package when doing the wizard.

  Then you can compare what the wizard is doing versus what is occurring in your dataflow task.

  ~PD