Controlling Package execution using script task

  • Hi,

    I have a big DTS package which i need to migrate to SSIS package. Current logic in DTS package has a logic where the package is divided into 6 subprocesses so that when there is any error it can start executing from the recent subprocess to avoid running the whole package next time.

    DTS package has implemented this logic in Activex script task. I would like to know if there is any existing/build-in tools that i can use in SSIS instead of writing the same logic in script logic.

    Please find the attachment for the same code found in DTS pacakge.

    Thanks in advance,

    Suresh

    Regards,
    Suresh Arumugam

  • Look up "Checkpoints" in SSIS. It is designed to save checkpoints so it can restart where it left off.

    You could also handle this through the control flow and some variables. You should not have to write any code to do what you are describing.

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

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