Post reply

Schedule SSIS on event

  • December 5, 2006 at 7:36 pm

    #115386

    I was wondering whether it is possible to schedule an SSIS package to run on an event, such as when a file is dropped in a directory.

    What I am ideally looking for is for some sort of check on the directory, and whenever a particular type of file is dropped in that directory, the SSIS package should fire and process the file.

    Does anyone have any ideas re this?

    Thanks

  • December 7, 2006 at 5:58 am

    #676554

    Hi,

    You could write a program using the filesystemwatcher class and then call the ssis package

    see http://msdn2.microsoft.com/en-us/library/ms136090.aspx

     

  • December 7, 2006 at 10:34 pm

    #676817

    This program would then be something like a service then, isn't it?

    I had a look and found a File Watcher Task on SQLIS.COM, which sort of does what I want, but in that as soon as it finds the file in the directory, it does what is provided in the OnFileFound Event, and then finishes the job.

    I want something to keep monitoring within a specific time range.

    I guess a service sort of a program would work.

    Thanks for your help mate, I might play around a little more and see what comes up.

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

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