Hi, I was just wondering, except scheduling the sql job based on an interval, say every 5 minutes, to scan a folder to see if there is any file ready for processing, is that possible that this process is driven by an event, e.g. as soon as a user places a file into the folder, the job kicks off immediately? Thanks,

There is somthing call File Watcher Task is avilable please have a look, http://www.sqlis.com/post/file-watcher-task.aspx Might be helpful...... :)Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

Have a look at file watcher task. Tweet me..

My 2 cents: a more standard approach is to create a Windows Service that implements the FileWatcher, then once the file is detected fire the SQL Agent Job (that calls the SSIS package) using sp_start_job.Arthur My Blog