Post reply

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

  • 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

  • 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."

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply