I need some input how to do the best way for the following condition:
We have an uploa, etxract and load file that is specified by the user and this user will set the time when it's going to kick off. BTW , we also keep the schedule in table in the database.
We are utilisiing Ms SQL 2005 SSIS package to upload, extract and load in this case.
On general ETL process, the time is set as a specific time and in our case is NOT.
Any ideas how to do this? I am thinking to create a small routime to check this schedule every 5 minutes or something and if it's passed the schedule time then run that SSIS package. But again I am open with new suggestion or other methods. People saying to use QUEUE but again I am not familar with this.
Thanks for your input.