Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Controlling Package execution using script task Expand / Collapse
Posted Tuesday, February 3, 2009 6:25 AM


Group: General Forum Members
Last Login: Thursday, July 3, 2014 5:46 AM
Points: 114, Visits: 404

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 Arumugam

  Post Attachments 
Skip Transformation if already processed.doc (20 views, 3.67 KB)
Post #648777
Posted Tuesday, February 3, 2009 7:23 AM


Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,661, Visits: 23,078
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.
Post #648826
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse