June 21, 2015 at 9:10 pm
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
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
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
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?
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy