I am not sure how to proceed on this but i have a ssis requirement.
I work in a retail company and i get sales file from the client on a daily basis.
What i want to achieve
As soon as a file is dropped on source folder location , an event i guess should be called which should run the sql job to run the ssis package i have it already in place to process the sales file.
In this way I dont have any dependancy to run the sql job at certain time.
Is it possible to achieve this.
Any question please let me know