opc.three (2/11/2013)
A SQL Agent Alert that leverages WMI could run a Job for you. Lookup SQL Agent Alerts and the WMI Event Class __InstanceCreationEvent.You could also do this a few different ways using an SSIS package that runs continuously watching for files:
Using the WMI Event Watcher Task in SSIS to Process Data Files[/url]
Using the Konesans File Watcher Task in SSIS to Process Data Files[/url]
Using the Script Task in SSIS to Process Data Files When They Arrive[/url]
+1 to the SSIS option. Use a For...Loop container to search through the folder you want to monitor. It's really simple
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience