Post reply

Run SSIS package when file is placed in a folder.

  • September 17, 2014 at 3:20 am

    #397357

    Currently, we have configured a SQL Agent task that run every 10 minute to run ssis package and check for files in folder to process. some time there are no files in folder but this job runs every 10 minute. I want to run a SSIS package on the event when File is placed in a folder if there is no file then job will not run. How can I achieve this functionality with in SSIS. I don't want to use WMI alerts. Thanks in Advance.

  • September 17, 2014 at 3:44 am

    #1745985

    If you've configured a SQL Agent job to run every 10 minutes then that's exactly what it will do - run every 10 minutes. You can change the SSIS package such that it checks for the existence of a file and only proceeds if a file is found, but that happens inside the job. You can't control the job from a package that is executed by the job.

    Regards

    Lempster

  • September 17, 2014 at 7:08 am

    #1746038

    I used WMI Event watcher Task available in SSIS with infinite loop.

    Explained well in link below.

    http://microsoft-ssis.blogspot.com/2010/12/continuously-watching-files-with-wmi.html

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply