Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Controlling Package execution using script task Expand / Collapse
Author
Message
Posted Tuesday, February 03, 2009 6:25 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, April 22, 2013 7:23 AM
Points: 97, Visits: 367
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


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

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,732, 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