Checkpoint File in SSIS

• ramkaay

  SSC Enthusiast

  Points: 136

  More actions

  January 30, 2012 at 12:21 am

  #144880

  Hi,

  A SSIS package is scheduled as a job in SQL Server Agent. This package has Checkpoint file. I've cancelled the job manually in SQL Server Agent(Package is not errored out). In the next run, package will be executed from the last run's task or from the beginning?

  Please clarify

  Regards,

  Ram

• Koen Verbeeck

  SSC Guru

  Points: 259095

  More actions

  February 3, 2012 at 12:42 am

  #1442225

  Why don't you run the job again to try and find out?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP