April 6, 2015 at 12:42 am
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
April 6, 2015 at 12:56 am
vipin_jha123 (4/6/2015)
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
Quick suggestion, schedule the execution of the package at an interval, if the file is there it picks it up otherwise exits.
😎
Alternatively you can use 3rd party tasks like the Konesans's File Watcher Task
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply