Post reply

Set delay timer using Script Component in Data Flow Task

  • 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.

  • 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?

    😎

  • 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

  • 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?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply