Set delay timer using Script Component in Data Flow Task

• am_mal80

  SSC Enthusiast

  Points: 142

  More actions

  June 21, 2015 at 9:10 pm

  #319186

  Hi All,

  Need your help to teach me how to set delay timer in Data Flow task using Script Component.

  I have tried many times but unsuccessful.

  Thanks in advance.

• Eirikur Eiriksson

  SSC Guru

  Points: 182947

  More actions

  June 21, 2015 at 10:33 pm

  #1806929

  am_mal80 (6/21/2015)

  ---

  Hi All,

  Need your help to teach me how to set delay timer in Data Flow task using Script Component.

  I have tried many times but unsuccessful.

  Thanks in advance.

  Quick question, why do you need a delay in the Data Flow?

  

• am_mal80

  SSC Enthusiast

  Points: 142

  More actions

  June 22, 2015 at 12:24 am

  #1806933

  Hello Eirikur Eiriksson;

  I create the lookup task to check Filename in Table from database.

  The problem is sometimes the file is created early than Filename generate in database table.

  So, the ssis program will skip the file to process and at the end of program, file will be moved to other location.

  *FYI From the Application to generate the file, I put udp to insert the filename to table.

  Thanks in advance

• Phil Parkin

  SSC Guru

  Points: 247159

  More actions

  June 22, 2015 at 1:24 am

  #1806938

  am_mal80 (6/22/2015)

  ---

  Hello Eirikur Eiriksson;

  I create the lookup task to check Filename in Table from database.

  The problem is sometimes the file is created early than Filename generate in database table.

  So, the ssis program will skip the file to process and at the end of program, file will be moved to other location.

  *FYI From the Application to generate the file, I put udp to insert the filename to table.

  Thanks in advance

  Why not modify your process to ensure that the file is created and that the table is updated before the data is needed?

  ---