4

I am having two tables, one is Staging and another one is Report. All processing happens in Staging and upon completion of such process I have to copy all the records to Report.

The Staging table contains millions of records so I just want to know what is the fastest way to copy this data to Report.

3 options which I know are:

  • Insert into
  • Select into
  • creating a package and executing it via a job.

Any help in this regard is much appreciated.

Jørn Schou-Rode
  • 37,718
  • 15
  • 88
  • 122
Raja
  • 3,608
  • 3
  • 28
  • 39

2 Answers2

4

another option is BCP out (queryout) and then BCP in/BULK INSERT

you can also use the BULK INSERT task in SSIS

SQLMenace
  • 132,095
  • 25
  • 206
  • 225
4

Have a look at Transferring Data from One Table to Another

It discusses

  • The INSERT INTO Method
  • The DTS Import/Export Wizard method
  • The BCP/Bulk Insert Method
Adriaan Stander
  • 162,879
  • 31
  • 289
  • 284