Post reply

How to execute SSIS package when a file is arrived at folder

  • April 6, 2015 at 12:42 am

    #295785

    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

    #1788842

    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