April 27, 2010 at 12:32 pm
hi all,
please help me with this regards
i have a process from a source system runs for a specific time and loads the data for that duration into a table.
the time may vary based on the rules they have at their end. but after completion of their process they will provide me a file in temp directory and the name will specify the starttime and endtime of that load.
ex: load_20100427110000_20100427120000.done
i have another ssis process which will read the start and end times from this file name and extract the data from source table and load into another table subsequently used in another process. and this process will delete the .done file.
now my question is i want to schedule my job to run when the .done file arrive in that folder everytime.
please share your ideas.
April 27, 2010 at 12:35 pm
How does the file get created? Is it FTP'ed, or is it being directly created?
April 27, 2010 at 12:59 pm
when the source process complete the last step of the process is to create this .done file.
April 27, 2010 at 1:02 pm
as of now i have a solution
i have two steps
1. load the data into stg table based the file name start and end times
2. run another package after the stage lkoad completes
my thought is
1. i will add a file watch task in the first package
2. in the schedule i will add this package as first step
3. as second step i will add to run the next package
4. on success of second step i will ask the scheduler to go to first step
iam i in right direction?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply