Control Flow of DTS based on table content.

• Gary Kenneally

  Newbie

  Points: 7

  More actions

  September 12, 2005 at 4:18 am

  #67043

  Hi,

  I have a DTS job which imports a CSV file into a table which is used as a lookup table by another process. The DTS job runs every 15 minutes as long as the file is there. Now in certain circumstances i want to be able to disable this job so the lookup no longer gets updated.

  I have a control table with the a true / false field. How can i get the DTS job to query this table and run if the value is true or End if the value is false ?

• Meghana

  SSC Eights!

  Points: 830

  More actions

  September 12, 2005 at 4:50 am

  #589029

  Based on the Value from the control table you can set a flag (Global variable) and using that flag you can disable/enable the step.

  use the example of Skip the execution of an individual task sample package

  in sqldts.com

   

  HTH

  Meghana

   

  ---

  Regards,

  Meghana