Hi ,
My requirement is to execute SSIS package, when a file is arrived at a D:\MSBI_and_SQL_Guide\Incomings folder,I do not want to start the package manually .
It is not sure about the file arrival timing ,also the files can arrive multiple times .When ever the files arrived this has to load into a table.I think, some solution like file watcher task ,still expect to start the package.
How can I schedule that using sql server agent.
Please suggest me the best way to achieve above requirement.
Regards,
Vipin Jha