multithreading and subpackages

• Shaunt_Kolf

  SSC Enthusiast

  Points: 106

  More actions

  September 21, 2009 at 2:17 am

  #141896

  Hi,

  I have a package and a sub-package which gets called from the main package. Variables will passed to the sub-package from parent (main) package.

  The problem is I’m trying to do multi threading.

  In the main package I have a for loop which runs forever(condition always true)

  Within that loop

  I have three tasks:

  First task : extracts some values and populate some variables which will get passed to the subpackage

  Second task: called the subpackage

  Third task:is the wait task that I have mentioned earlier (waitfor DELAY '00:01:00')

  My aim is to be able to run a new instance (with the variables) of the subpackage exactly every minutes regardless of how long the subpackage will take to run.

  Thanks in advance

  S

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  September 21, 2009 at 8:31 am

  #1056258

  This is duplicate post. Your question will be answered here.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/