SQL server 2014 and VS 2013 - Give batch size to Excecute SQL task

• ankithimmatlalshah

  Ten Centuries

  Points: 1090

  More actions

  June 25, 2015 at 5:58 am

  #309399

  Hello everyone,

  I'm performing purge operation in SSIS package. I've used Execute SQL task to perform purge over around 60 different tables one by one in For each loop container.

  Client wants to perform purge in batches for performance, hence this package has batch size parameter.

  Can you please advise how to use/apply the batch size to Execute SQL task?

  Is there any other alternative that perform purge operation in batches?

  Any help would be greatly appreciated.

  Thanks,

  Ankit

• free_mascot

  One Orange Chip

  Points: 27164

  More actions

  June 25, 2015 at 6:42 am

  #1808024

  Check the following link which might help you. You can modify the same as per your requirement.

  http://www.keepitsimpleandfast.com/2009/09/use-batches-to-delete-large-number-of.html

  HTH

  ---------------------------------------------------
  "Thare are only 10 types of people in the world:
  Those who understand binary, and those who don't."