Running an SSIS package when a trigger file arrives on Windows Server using Sql*Agent
Posted on 2013-06-21
We are trying to run an SSIS package when a trigger file arrives on Windows Server.
So I need a job to run every 5 minutes, and if it finds my_trigger_file.txt, then run an SSIS package.
What kind of job would this be ? Sql Agent would run the job "check for trigger file", and then Step 1 is to see if the file exists. If it's there, then Step 2 run the SSIS package.
I have little experience with Sql Agent, but mostly looking for - what kind of job polls for the file ? And then if "success", Sql Agent has to know that to run the SSIS package.