Hi Guys
I have an SSIS package which is already running without any issues.
My existing package is copying data from csv to sql server with transformations as per requirement.
When the file is copied from csv to sql , I am also archiving the file at the same time.
These are all running ok.
The only gap i see is that I have to manually run the job as I cant automate it because we don't know the frequency of the file receiving..
What I am sure off that we will receive one file at a time. Their wont be two files in our directory at the same time.
Is their a possibility that i can automate the step.
What i was thinking(if possible in the simplest of way possible) is when I receive the file and when the file is present in our file directory I then want to trigger my sql job which will run my ssis package and then dump the data into sql server.
One solution i can see is WMI EVENT WATCHER. But is thier any other alternative i can use apart from WMI EVENT WATCHER.
Any simplest way of achieving this task.. Please let me know
Thanks for the help and advise
Regards
Farhan Jamil


