Export SQL Table data to Flat file

• Diyas

  SSCarpal Tunnel

  Points: 4851

  More actions

  April 15, 2016 at 7:08 pm

  #400027

  Hi,

  i am planning to export the 2 million records to flat file.but it is taking time .how can i export the data by batch wise .

  can one suggest in ssis or other way.

• homebrew01

  SSC Guru

  Points: 55548

  More actions

  April 15, 2016 at 7:44 pm

  #1872540

  BCP may work well.

  If you use SSIS, I think there are some parameters to set batch size that can help, instead of trying to export all at once.